Append up to 500 linked records

[Karren Lorr]

Hello

I have 2 tables

TableStudents
StudentID
1stName
Surname
Etc
Etc

TableOrders
OrderID
StudentID (this is the linking field)
Item
ItemCost
etc
etc


Sometimes a bulk order will be made for an item by anything up to 500
students. At the moment I am just opening each student’s form and filling in
the details. This can take up to 2 days.

For bulk orders all the details are always the same.
Eg
Item = Book ABC
ItemCost = 12.34

Is there a way in which I could just type these details just once and append
or add them to the Orders table so that each student has the same order (but
it will be a new OrderID for each person)

Thank you

 

[Douglas J. Steele]

Is OrderID an Autonumber, or are you assigning it a value?

If it's an Autonumber, you should be able to create a query that takes each
row from TableStudents and includes Item and ItemCost values. You can then
turn that query into an Append query.

 

[KARL DEWEY]

Yes, but it will depend on how your OrderID is created/formulated. If it is
an autonumber then it is very easy.
INSERT INTO TableOrders ( StudentID, Item, ItemCost )
SELECT TableStudents.StudentID, "Book ABC" AS [XX], 12.34 AS [YY]
FROM TableStudents;

 

[Karren Lorr]

Thank you Douglas and Karl.