Hi,
Currently I have a parent table called "TBL_Admission_Data" with a unique ID being generated by MS Access. One of the fields in the parent table is called "Insurance Authorization #" and will be a 15 (or more) digit number. I've built a child table called "TBL_CONCURRENT_REVIEWS_Extensions". The two tables aren't connected yet but when they are, I would like the "Insurance Authorization #" entered in the parent table to become the unique ID for all the records in the child table. So I want what ever records are created in the parent table to automatically copy the Insurance Authorization # to the child table. Is this possible or will the child table need a separate unique ID#? Thank you for your help.
Regards,
Saabra
Bookmarks