lay out form subform 3 levels??

[Guest]

I am trying to put together a FORM where the employee (mgr) schedules
cleaning jobs to be done for that day.
Each RECORD will be a GIVEN DAY. It will include the employees available
for that day and then ALL jobs that need to be done. Once the job is
scheduled for an employee for that day - I would like that choice to NO
longer show up on the drop down list for that Given day.


Not sure how to set this up with main form -subform what parent-child should
be with the tables I have -if I need additional table,fields or queries to do
this.

Any ideas on how to not let THE JOB show up once selected for That day and
then on a new
record (new day) all dropdowns for jobs get repopulated and start all over
again?


Here are some of the tables I have


tblCleaning
Cleanid(PK)
joblocautonum
location
job
dateassigned
Clockid

TblPersonnel
Clockid(PK)
Firstname
Lastname
Status
Shift
Frequency

TblJobsAtLoc
JoblocAutonum(PK)
Job
Location
Room
estTime
ProcLink
MixingIstr

Thanks,
barb



Thanks,

 

[Jeff Boyce]

This newsgroup is dedicated to questions about tables and database design.
You might find more folks with answers if you post your question in the
..forms or .formscoding newsgroup...

Regards

Jeff Boyce
Microsoft Office/Access MVP