I'm having trouble creating multiple Order detail records for each product. Can anyone help?

In my database I have, among others, a DataSet (I call them tables) for tblOrders and tblOrderDetails.

tblOrders contains records about Which Customer bought what Product and When

tblOrderDetails contains records such as OrderID, how much they paid (price isn’t the same for each customer), how many they bought and what store did they buy it from.

My problem comes when I’m inputting a new order. I want it to be easy for the User so I have a workflow that creates a new tblOrder record and adds the relevant info from Inputs they’ve filled in. Then I create a new tblOrderDetails with the results of Custom States and other values in inputs BUT this results in one Order number for the OrderID field in tblOrders which is then used to create the OrderID in the tblOrderDetails. This means that if a customer orders several different products in the same order, I end up with a LIST of Products and Quantities and Prices etc in each record single record in the tblOrderDetails whereas what I really want is to create a new record for each Product they’ve ordered and to have the OrderID repeated in multiple tblOrderDetails records so that I can have separate Quantities and Prices etc. But I don’t know how I get this to produce a new record for each Product in an order and then populate the tblOrderDetails with that.
If you’ve read this far and are still with me, I’m incredibly grateful and I’d welcome any suggestions. I’m in the UK and have to get home now but I’ll be back to provide more explanation if needed in the morning…
All the best

If you are using the any of the paid plans then you can run a backend workflow on a list and pass in the list of products, creating a new tblOrderDetails for each one.

That sounds phenomenal and exactly what I need. I’m still on a freebie plan so I’ll upgrade it. I’m driving at the moment (well, I’ve stopped) but I’m so, so grateful for this information. I’ll start coughing up cash tomorrow and will learn about back end work flows. I suspect this is going to really help me. Thank you!

1 Like

They are a game changer