Dropdown selection for a record
How can associate a primary record to another related secondary record using a list of primary records each with a drop down list of available secondary records? We have a series of orders in our s...
Forum Discussion
thank you for your help. That works but means updating one record at a time. My ideal solution was to have a list (report?) of items and to select the delivery note from a dropdown field inside the list (one per item) so it could be processed quickly and efficiently. Doing it one record at time would be too time consuming.
On your Orders form - you can set the "Items" embedded report to be Editable, so that means you can edit all the Items in that list.
i.e.
1) Go into form settings for your Orders Form
2) Select the Report Link that is showing your Items
3) Under "Display the related Items directly on the form", check Editable
4) Save
Now when you edit an Order - you can go to the Items section, and select the Delivery Note dropdown directly next to each Item.
Just need to make sure that the "Delivery Note" column is in the embedded report for Items that is being used in the Orders form.
i.e.
1) Go into form settings for your Orders Form
2) Select the Report Link that is showing your Items
3) Under "Display the related Items directly on the form", check Editable
4) Save
Now when you edit an Order - you can go to the Items section, and select the Delivery Note dropdown directly next to each Item.
Just need to make sure that the "Delivery Note" column is in the embedded report for Items that is being used in the Orders form.