jprochelle
Technical User
I have two tables: In House and Commercial. In both tables there is a CUSIP field. I want the form to only display those CUSIPs in the "In house" table that have a certain criteria for a field in the "In house" table (i.e. only show those that have "yes" in the COOP field). At the same time, I want the form to populate with the details from the "Commercial" table. So, one entry would be the CUSIP from the In house table, and the corresponding 'Description', 'ID', 'Location' from the "Commercial" table.
Is the only way to set this up with unique relationships? This is a problem because there are duplicate values. Is there any good way to query/append query this information into the form..
Thanks,
Is the only way to set this up with unique relationships? This is a problem because there are duplicate values. Is there any good way to query/append query this information into the form..
Thanks,