I have following database structure:
- I would like to generate a purchase order from the (not directly connected) Purchase Item table in tadabase from the list/table of purchase items.
- And I would like to generate a purchase order with purchase order items in one form (which is difficult then the purchase order items should be connected to the not yet generated purchase order.
The handicap: I would like to add information like a) who wants to order and b) who is handling the PO, which is part of the Purchase order information, so just generating a record is not enough, I need to enrich it with information.
Obviously it should be 1 action, not first make a PO and then in a second action to enrich the PO with additional data and/or add purchase items.
Can someone help me here?
Do I need to use another structure of tables to do this?