Update case number field in multiple Tables using one form

[DJOKC]

Hi everyone,

I created a Database with 10 tables, Case number is PK in Table one and all other tables are related by Case Number but the case number is not PK in the other 9 tables. Is there a way to populate Case number in all 10 tables using one field on a single form? I am a beginner and do not know much. Any help will be highly appreciated.

Thanks

[always404]

Why do you need to do this?

Your other 9 tables can have the case number as a selectable foreign key.

What exactly is happening the the form that will contain this field?

[Missinglinq]

1. Make a Main Form with your 'Table One' as its RecordSource
2. Make nine Subforms, using each of the related Tables as their RecordSources
3. Use the Case Number in the Link Master Field/Link Child Field Properties.

When you use this scenario, creating a Record in a Subform will cause the Access Gnomes to insert the CaseNumber into the Subform Record.

With nine related Tables, I'd probably use a Tabbed Control, placing each Subform on a separate Page.

Linq ;0)>