I have created several tables that share an auto id number, I have created the relationships exactly the same in every table, but for some reason the auto is (primary key) only shows in the first two related tables and not the others. When I go to enter data in the other related tables it gives an error saying my primary key field is null and when I open the table sure enough the auto id is not there. Any suggestions what might be causing this? I've never had this happen before.
Thanks!