Unanswered: importing to a one to many relationship
Ive imported a table from an old DB that has some data that is useful. This is my situation.
the old table has the following fields that need to be split into to two tables that are linked e.g
tblreferrals(old data) to be split in to 2 table
In need theSurname, GivenName and MPMS in the Clients tables and the rest of the data linked to my Tenant_Property_booking table which has Address, dateIn and DateOut. I need to data to match up. I know how the copy form one table to another but not when the needs to be data in the many side.
Do I need to do an update query and, if so, how do I do this. I can I do this. Ive been dieing work this out for a long time.