I am new to CR10. We have CR10 installed connecting to an Oracle 9 server. I have created links around the 10 tables to be used in the report. I have set one field (alpha-numeric) to be the parameter criteria for the user to select. I would like to create formulas to display the corresponding fields from other tables based on this selection. I would prefer it in Basic syntax (but Crystal will do).
In Psuedo code, this is what I am trying to do:
Display table3.field2
Where table1.field1 = returned parameter value
and table1.field2 = table2.field1
and table2.field2 = table3.field1
txs for the help!
In Psuedo code, this is what I am trying to do:
Display table3.field2
Where table1.field1 = returned parameter value
and table1.field2 = table2.field1
and table2.field2 = table3.field1
txs for the help!