User Input Form with defauly values

B

Brian

Thanks in advance

I am trying to set up a tracking database that needs to track several stages.
Each stage captures the same type of information:
Stage1 = StaffName, StartDate, EndDate, Comment
Stage2 = StaffName, StartDate, EndDate, Comment

With help from this group, I have several tables:
tblStudies:
StudyID (PK)
StudyName

tblStaff:
StaffID
FName (PK)
LName (PK)

tblStages
StageID (PK) (this will be 1 -20)
StageName

tblStudyStages
StudyStageID
StudyID (FK)
StageID (FK)
StaffID
StartDate
EndDate
Comment

My question is. Is there a simple way to set up a form so that each time a
NEW record is created it automatically displays The StudyInfo and All 20
Stages (with entry available for the Dates, comments etc,, for each stage).

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top