Page 1 of 1
Do a Scan with a Lookup
Posted: Thu Mar 17, 2005 10:56 am
by 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
=> RE: Do a Scan with a Lookup
Posted: Thu Mar 17, 2005 12:47 pm
by 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
==> RE: Do a Scan with a Lookup
Posted: Mon Mar 21, 2005 4:20 pm
by 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.