Form Design - Tabbed Form with Subforms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael - 07 May 2007 16:55 GMT

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

Reply to this Message

Damon Heron - 07 May 2007 18:49 GMT

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

> Hi Folks - I am designing a form to enter data with the following
> relationships:
[quoted text clipped - 6 lines]
>
> Michael

Reply to this Message