Too many links 1

[trenttc]

Table1 id and Table2 id are linked to Table3 id, which has a needed text field. While printing on the same line, Table1 id and Table2 id need to lookup and display their respective Table3 text field values. What's an efficient formula? CR 11.

 

[groggle]

While printing what on the same line?

You need to provide more information about what the rest of the report is doing / displaying.

 

[Madawc]

If you want two different Table 3 values on the same detail line, for the differing values for tables 1 and 2, then you need to add Table 3 again. It will be added as an alias and can be treated as if it were a separate table.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10