I have a report that has two tables that are linked together by the code field. There are instances where I want to display a field in table2 based on a different link. For example table1 and table2 are linked by table1.code and table2.code. I am displaying the table2.desc field. There are times when i want to display the table2.desc field where table1.differentcode is equal to table2.code.
I thought perhaps I could put a query inside a formula, something like:
Description = SQL_Query("select table2.desc from table2, table1 where table1.differentcode = table2.code");
This is just an example to explain what I am looking for - any suggestions?