Form Design - Tabbed Form with Subforms

[Michael]

Hi Folks - I am designing a form to enter data with the following
relationships:

The main form is legal case data such as name, address, DOB, etc. For each
case, there can be multiple charges, and for each charge there can be
multiple victims. What's the best technique to display this related data on
a form? Tabs? "Popup" forms? Can you create a victim form on its own tab of
the main form? Thanks for any ideas?

Michael

 

[Damon Heron]

Start with the design of the tables, not the forms. There should be a Case
table, as you mentioned, then a charges table with a foreign key to the case
table. Use a main form with the Case data, and a subform for the charges
for each case. Victims are related to the Cases, not the charges, correct?
If so, you can have another subform with a foreign key to the Case table.
this can be on one form or you can put each on tabs, your choice.

HTH
Damon