Linked Tables behind a Form

[davegauthier]

I have 7 tables to track client data. The 1st table uses AutoNumber to create the 'Client ID' number. The other 6 tables are linked to this table, and in turn each other, through the 'Client ID' field.

All information entered in all 7 tables is done so on one form. This form has a tab control to separate the input fields.

The problem is this. If I enter information in the form, but no field in one or more of the tables gets filled (table gets left completely empty because the fields were not relevant to that record), the record does not save itself to where it can be viewed in the form anymore.

I have programmed a command button to copy the 'Client ID' from the 1st table to the rest, and so far this works, but I would like to have this done automatically without any action required by the user. I tried the 'OnDirty' for the ClientID field on the form, but I do not think that works. Mybe 'OnUpdate'?

Any suggestions?

 

[RuralGuy]

Hi Dave,

Why do you require records in tables when as you said:

...the fields were not relevant to that record

or do I not understand the question? Do you have your relationships defined and have you completed the LinkChild/MasterFields correctly?

 

[Pat Hartman]

Please don't post the same question multiple times.