Nagtegaal
Member
Hi all,
From my order item, I would like to built up the price with some price details by multiple lines per order item.
In one list I have two joins, the first from the 'kan_order' to the 'kan_order_item' the second to the 'kan_order_item_prijs', to be able to built up the price from multiple lines. So in the list I created these joins:
INNER JOINS are:
kan_orders.id > kan_orders_item.order_id
kan_orders_item.id > kan_order_item_prijs.order_item_id
Yet when trying to add data the fields for kan_order_item_prijs show up after the first repeated group, so I can only add detail data for the first item, where I would expect this (subsub)form per item:
Beside that from the second item the meal is not stored, receiving a built in error when saving the record:
Is it just programmed this way or am I missing something? Any help would highly be appreciated.
From my order item, I would like to built up the price with some price details by multiple lines per order item.
In one list I have two joins, the first from the 'kan_order' to the 'kan_order_item' the second to the 'kan_order_item_prijs', to be able to built up the price from multiple lines. So in the list I created these joins:
INNER JOINS are:
kan_orders.id > kan_orders_item.order_id
kan_orders_item.id > kan_order_item_prijs.order_item_id
Yet when trying to add data the fields for kan_order_item_prijs show up after the first repeated group, so I can only add detail data for the first item, where I would expect this (subsub)form per item:
Beside that from the second item the meal is not stored, receiving a built in error when saving the record:
Is it just programmed this way or am I missing something? Any help would highly be appreciated.