- Make a Main Form with your 'Table One' as its RecordSource
- Make nine Subforms, using each of the related Tables as their RecordSources
- 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)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007