Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / June 2007

Tip: Looking for answers? Try searching our database.

Database for Project Stages

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
steve - 05 Jun 2007 18:03 GMT
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 - 06 Jun 2007 10:10 GMT
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

> A Project has 3 stages:
>
[quoted text clipped - 16 lines]
> Thank you,
> Steve
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.