form - subform

B

babs

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
 

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

Similar Threads

lay out form subform 3 levels?? 1
sum calculation in subform based off of a query 0
Populate a Dropdown list for Job Location Autonumber based on what 0
Check previous record of another field null 6
Multiple Instance of same form retrieving different data. 1
Form-Subform for weekly Schedule 0
How to auto-populate some fields from the last record to the newon 1
Append Query to Mainform and Subform 0

Top