Hi Community,
We have stationary management for office employees where they can order the stationary item available for that location. For this we have table that stores item name, quantity and location and second table(order number, item, quantity, location, ordered by, time) will have the all the orders placed by employees. Here I have created multirow variable set for the item and quantity where it will list only those items which are avl for that location using reference qualifier. This variable set I am using in record producer so that whatever order will be place in second table new record insertion happen. But here I want to create multiple record with same order number(auto numbering field) having different item selected on form. so here for a order only item and quantity will be different all other fields will be same under a same order number.
Can anyone please help me to create this ?
As using record producer and mapping done by producer.mrvs, it is mapping only first items and creating only one line for a order. But I want to create different lines for each item with their selected quantity under same order number.
Please let me know if you are confused or any more information is needed.
