I am a school student working on a Microsoft accessdatabase, and have little experience in the software.
I have created an input form for students to enter theirinformation using sub forms and tab controls. I have 5 separate tables thatrecord specific data: student details, contact details etc. From these I maderelated forms. In my combined student input from, each tab in the tab control hasa sub form from these individual table forms. After inputting all of my data, Iopened the related tables and realised that the primary key used by all thesetables/forms was only being recorded from the first tab (student details). Inthe other tables/forms (contact details etc.) a primary key for that record isgiven from that table's ID, but not the relating foreign key.
When I created the sub forms I linked them through thewizard with this primary key, however, it does not record in my tables. When Icreated the blank from my initial record source was the Student Details tables,however I’m not sure if this has something to do with the problem. Is there a method to either fix or work around this issue?