Is there a way to force access, or perhaps I am doing somethign wrong, to save the primary key into a related tables foreign key? For example I have one primary table with a primary key (UserID) set to autonumber. I have a couple of other tables related to this primary table and they use UserID...