S
shelter
I am running Access 2003.
I imported an old excel spreadsheet into a single table in Access. I
need to append data into two related tables as follows:
FirstName, Lastname and Email into tblPersons, which includes an
autonumber primary key; Dayphone and Evephone into tblPhoneNumbers,
which contains an autonumber primary key and tblPersonsID as a foreign
key.
I have searched the groups and am concerned that I may not be able to
do this and keep the integrity of the phone numbers. The autonumber
primary keys may be problematic, but I cannot think of another way
around assigning a PK to these records.
Any help would be appreciated.
DJohnson
I imported an old excel spreadsheet into a single table in Access. I
need to append data into two related tables as follows:
FirstName, Lastname and Email into tblPersons, which includes an
autonumber primary key; Dayphone and Evephone into tblPhoneNumbers,
which contains an autonumber primary key and tblPersonsID as a foreign
key.
I have searched the groups and am concerned that I may not be able to
do this and keep the integrity of the phone numbers. The autonumber
primary keys may be problematic, but I cannot think of another way
around assigning a PK to these records.
Any help would be appreciated.
DJohnson