Do a Scan with a Lookup

[jmiskey]

I have heard that with Version 10.0, it may be possible to do a Lookup that "Scans", or returns multiple records for each record in your master database (I need to use the Lookup functions, I can^t link to the necessary database and do the scan that way).____Is this true? How would I do that?____Thank.s

[kfleming]

The lookup functions will always return the only first value from the lookup table. You would indeed need to use the relation dialog to set a one to many relation.____Kathleen__R&R Support

[jmiskey]

I guess that I will need to set-up a control file to do this, as the Mmain, starting database is different for different records.