Uploading data.

[Jenny1]

I have created my database - I now need to upload data from my old database.

I have the old data in an excel spreadsheet and have edited the data so that it matches the coloums in the new database.

I have one problem,

I can upload all the person data into the person table

and I can upload all the organisation data in the organisation table

(I'm assuming I just copy and paste it into the tables in the new database.)

BUT and this is a big BUT.. the employment table is the linking table where you select an organisation from the drop downlist and you select a person from the person dropdown list, you add other details about emplyment and save the record.

Does this mean I will have to do this manually, i.e create all the links manually??

And is my cut and paste method above corect??

Thanks is advance

Edit: I have attached the database to help you understand

 

[Jenny1]

Any ideas on this boys? - please ask if I havent explained this properly