Synchronizing IDs accross multiple tables

[stanond]

I have a similar problem. I have a form displaying some primary information, this form has six command buttons, each designed to open a form from a different table. I want to associate these records with the form displaying the primary information. Relationships are as follows; Primary Information ID is set to all other tables ID. On my first attempt, if I did not enter data to one of the other tables opened by the command button, an auto ID was not created - messing up the synch of the records.

My question is this: To keep everything synched, when the form is opened can I force the creation of a record to all the other tables this form openes to keep the ID's synched?

These records must eventualy be created, but the user may bail out before each form is opened.

??? Help ???

Related Thread: Synchronise

[JKing]

Hi, you had posted your question under an older thread. This is discouraged as it can clutter up the original poster's feedback and will limit the feedback you yourself receive. I have taken the liberty of splitting your post into it's own thread and assigning an appropriate thread title for you.

MODERATOR

[NeoPa]

You can do this but it would take a fair amount of code.
It may be possible to do it without the extra code if using sub-forms (I'll let someone who knows them better discuss that) but I would :

1. Open the related form with a filter which shows which value you want (which defines the relationship to the master table).
2. Have a control in the opened form (can be hidden if you like) which holds that value.
3. Make sure the Control.DefaultValue is set to the value found in the filter when the form is opened.

This will ensure that only matching entries are shown AND that all new entries will be matching.

BTW. Nice work JKing. You were absolutely right to "take the liberty" of splitting this thread out. Good job.