Unanswered: update records (keys) on related sister tables
In an Access database, I have a Volunteer file, and associated with it and with the same primary key value as the Volunteer table, are AdditionalInterests, Education, and other files. When I write out a record to the Volunteers file, I want to write records with the same primary key value out to the sister files, so that when the user has time to enter the extra information, the placeholder (primary key) is already there and the correct record is updated, and enforces the relational nature of the system.
what's the best way to write to the other few files when I write out a volunteers record?
Sounds like a classic case for using subforms, providing I understand your question.
In the related tables (the "child records"), they would each have their own primary key, and they would each have a "foreign key" (which is the primary key from the parent table). I am assuming this is what you want, so that multiple Interests can be added relating to a single volunteer, for example.
IntKey VolKey Interest
1 1 Programming
2 1 Bowling
3 2 Programming
4 3 Cooking
4 3 Soccer
sure, but why? in the parent child relationship model, it's ok if you don't have any children at first (or ever) for some of the records. Based on what I know of your question at the moment, it doesn't make sense to create essentially empty records to "hold a place" for potential future child records. The sub table containing the child records will have it's own unique primary key, and will happily accept the foreign key (the parent) at any time.
When you go back to add child records later, you open the form back up, select the volunteer and then start adding interests, etc.
In fact, if your child table is one-to-many (multiple interests per volunteer, for example), the primary key of the child has to be unique (and independent of the parent key) anyway.