I have a master name address etc table and a table which was created on its own to collect some of the same type of data.
They both have an auto-incremented id key field, I want to be able to attach the second table based on the zip plus 4 fields in both records.
Can I declare the zip4 field as a foreign key or do I need to first run an inner join on both tables and build a refrential table first? I will not be adding any new records to the detail table.
Thanks
Jim Freeman