View Full Version : One to many lookup problem


03-09-2005, 01:07 PM
Where inv_line.dbf contains 2 records
INV_ID="1" Descript="Long Distance Sales"
INV_ID="1" Descript="Cell Purchase"

and conditional report object uses
function *any(Descript,"Cell Purch") for layer 1

report is supposed to print layer 1 for invID 1 but it doesn't. Seems to see only the first record but not the second one with the "Cell Purch" text string.

Romy Huang
03-10-2005, 11:30 AM
because the function you use is "Cell Purch", so just one record come up.

try function *any(Descript,"1") link to inv_id,


try group by inv_id in your report.