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
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