CallumMascall
New member
- Local time
- Today, 20:54
- Joined
- Sep 18, 2020
- Messages
- 15
Hi there, I have an order tracking database (its the pre-made Goods Database by microsoft but modified slightly to my needs)
I have the purchase order form with the subform that allows for multiple products to be selected from the selected supplier
I am making a report that will be an order form to send to the supplier with the items, quantities, prices etc. I can get normal records from the form to the report fine. However i am confused as to how i can get all of the items from the subform into the report as they are under the same field name in the tables.
Is anyone able to tell me how i would go about doing this?
All of the items from the subform have the order number attached to them from the main form so they are associated in that way.
for example i order a wheel bearing, brakes, engine mount, etc from 1 supplier. This is all on one form with those items on the subform, how can i get all of these different items in the subform for that order number onto the one report to send as an order form to the supplier?
My problem is because the items will be under the same field name in the subform's table, im unsure how to go about getting the multiple different items onto the report
Sorry if my wording is hard to understand, its hard to explain XD
I have the purchase order form with the subform that allows for multiple products to be selected from the selected supplier
I am making a report that will be an order form to send to the supplier with the items, quantities, prices etc. I can get normal records from the form to the report fine. However i am confused as to how i can get all of the items from the subform into the report as they are under the same field name in the tables.
Is anyone able to tell me how i would go about doing this?
All of the items from the subform have the order number attached to them from the main form so they are associated in that way.
for example i order a wheel bearing, brakes, engine mount, etc from 1 supplier. This is all on one form with those items on the subform, how can i get all of these different items in the subform for that order number onto the one report to send as an order form to the supplier?
My problem is because the items will be under the same field name in the subform's table, im unsure how to go about getting the multiple different items onto the report
Sorry if my wording is hard to understand, its hard to explain XD
Last edited: