I am new to Access. I am currently working through the new perspectives book and on chapter 8. So I know just enough to be dangerous. I am trying to set up my first data base from scratch. Currently I have 3 tables. Two of the tables are from importing excel spread sheets.
First table Employee (primary key User ID)
Second table Call Date (foreign key User ID)
Third table payment data no primary key or foreign key currently
My problem is that the second two tables are excel imports the the multiple entries for all identifiers.
1. Can I tie two foreign keys to one primary key?
2. Can I tie two tables by foreign key with no primary key? P-F-F