Appending multi records

[Vette00]

I have a form were the user enters information about a job (ie Date, Time, Select days to work, and # of People needed.) Then at the end of the week the user goes to the assignments table and picks employees and assigns them to the jobs. I am using an append query to add records from the tblJobs table and adding them into tblassignments table. I have queries for each day. The problem is how do I get Access to add multiple records to the assignments table based on the number of workers requested.

 

[Remou]

Do you wish to assign people from a table? If so, it is possible that top values would suit:

[tt]INSERT INTO Table1 ( IDNo )
SELECT TOP 5 Table2.IDNo
FROM Table2;[/tt]

Do you wish to add an outline record? If so, a 'count' table, that is a numbered table, may suit:

[tt]INSERT INTO Table1 ( IDNo )
SELECT (1234) AS Expr1
FROM tblCount
WHERE (((tblCount.CountVal)<=5));[/tt]

 

[Vette00]

I want to add the date, times, and job to the assignments table. I will assign them from a different form. The problem as I see it is there is only one job and it can have many days and many people. I need to add many days which i did but I don't know how to add many people.