I have a database that has a jobs table and an Assignments table. Everyweek the user select how many days the job will run in the next week and how many people are needed per job. I need to fill the assignments table with all the requests and assign workers to each job. Basically I need the form to fill records into assignments table based on the # of days and the # of workers needed. Ex. Job A is needed on Mon Tues Fri and requires 5 people this should produce 15 entries in the assignments table.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
