fomular in table SQL

[luckroth]

I have two tables(Table1 and Table2).
property Table1
IDTest1 int
IDTest2 int

Property Table2
IDTest3 int
IDF (formular)


can i used field IDTest2 in table1 in the formular in the table2?
many thank for your help

[WarlockSoul]

Hi,

The direct answer to your question is No. You could do one of the following:

a) Import the data in table1 to table2
b) Create the same formula in table1
c) Write the formula on the fly when doing a select statement
d) If you are going to use the same formula frequently, I would suggest looking at the Online book for creating a function.

Hope this helps.