Best way to code subforms

[i-asaipillai]

Hi there

I am building an application of Employee details. The application contains of the following:

Employee Details (Main table)

The following are child tables related to the above master table:
a.. Employment History (Sub table)
b.. Languages and Proficiency (Sub Table)
c.. Units (Sub table)
d.. Diviions (Sub Table)
Now which is the best way to display information from all of these tables
ie in one record?

I was thinking of using tabbed forms with a tab for Employment History,
tab for Languages and Proficiency, Units, Divisions etc.

Can these be displayed in a master-detail like manner?

Thanks in advance

Chris

 

[Duane Hookom]

You can use subforms on tabs to display the related tables. The only
draw-back that might occur is that you are loading a lot of records into
your form(s).

--
Duane Hookom
MS Access MVP
--

Hi there

I am building an application of Employee details. The application contains
of the following:

Employee Details (Main table)

The following are child tables related to the above master table:
Employment History (Sub table)
Languages and Proficiency (Sub Table)
Units (Sub table)
Diviions (Sub Table)
Now which is the best way to display information from all of these tables
ie in one record?

I was thinking of using tabbed forms with a tab for Employment History,
tab for Languages and Proficiency, Units, Divisions etc.

Can these be displayed in a master-detail like manner?

Thanks in advance

Chris