Database for Project Stages

[steve]

A Project has 3 stages:

1. Prospect
2. Estimate
3. Detail

I am building a database where the user opens a project, and sees a tab
control with 3 tabs, one for each stage.

I have a tblProjects, tblProspects, tblEstimates, and tblDetails. These
tables are linked by ProjectID.

Should I build a subform for each stage, and place them on the tab control?
The Child/Parent link would be ProjectID. How can I limit the subform to
only show the record for the current project?

Please advise if you see any problems with this design.

Thank you,
Steve

 

[Nikos Yannacopoulos]

steve,

You're on the right track. Re. linking of subforms to parent, the
easiest way is to activate the Control Wizards in form design, if not
already active (the button with the magic wand on the Toolbox toolbar),
and then add the subfoms; the pertinent wizard will kick in, and force
you to select controls on either side (main / subform) to link on.

If you already have the subforms in place, toy can do it manually by
selecting each subform in turn, and changing the values in the Link
Child Fields / Link Master Fields properties on tab Data (or click on
the button with the ellipsis sign that appears on the right of the
property when you put the cursor into it, to invoke the wizard).

HTH,
Nikos