rickm - 1 month ago

I've seen a few references around that make me believe this is possible, but I'm struggling to find any documentation or other information on how it's supposed to work.

The situation is that I have a fairly simple Order > Order Items structure (i.e 1 order, many items). So in the original streams I've set up, on the order_items table I have an order field type of relationship - that works fine. But now I need to have a frontend based form where you can view and edit an order, along with the data in each order item line.

The problem is I can't seem to be able to retrieve any sort of form for each order item, let alone save it. The only examples I've found was a forum post that seemed to not be followed up on, and the multiform docs here, which don't really explain how you'd do this: https://pyrocms.com/help/developer-tools/form-builders/combining-form-builders

For reference my structure is:

  • ORDERS (id, order_no, customer_name, order_date)
  • ORDER ITEMS (id, order_id, item_name, unit_price, quantity, line_total)

Is this even possible or should I look at another way of doing this?