Large form created from many tables

[Guest]

I have several tables with one-to-one relationships. I have set the primary
key for each of these tables the same(for example, vehicle ID #). I want to
fit all the possible fields from all these tables into one form, preferably
using the tab control(each tab would contain the fields of a different
table). The end result: when a new vehicle is being added or a vehicle is
being maintained all the necessary fields are entered and/or updated. When
viewing, all fields pertain to the same vehicle, even though they are in
different tables. Any suggestions or examples on how to go about doing this?

 

[JulieD]

Hi Helga

as a starting point - create a query drawing in the fields you want, base
the form on the query.

(just a word of warning though, big forms are great if screen resolution is
set to 1024x768 or higher - however, if you get a user with a screen res of
800x600 you'll have a problem).

Cheers
JulieD

 

[Rick Brandt]

I have several tables with one-to-one relationships. I have set the primary
key for each of these tables the same(for example, vehicle ID #). I want to
fit all the possible fields from all these tables into one form, preferably
using the tab control(each tab would contain the fields of a different
table). The end result: when a new vehicle is being added or a vehicle is
being maintained all the necessary fields are entered and/or updated. When
viewing, all fields pertain to the same vehicle, even though they are in
different tables. Any suggestions or examples on how to go about doing this?

Rather than a query combining all of the tables I would use one main form with
each TabPage having a subform for the other tables. Then the matter of getting
the Primary Key value propagated to all of the other tables is taken care of
automatically. Otherwise you have to take care this yourself.