How do I change the same field in 2 data tables with 1 form?
I am trying to make an app for inventory management and tracking quantity of items. I have 2 data tables -
a fixed dimension data table which cannot be added to, but can be updated. This is used to show the kind of items we have and their relevant containers, and most importantly last recorded quantity (the part i am struggling with). This is the main view, and the user can identify items they seek through this view. An action is mapped to the navigation to a form which submits a new row in another, second table (below), autocompleting some fields from this view when selecting an item to edit/action.
a data table which can be added to, through a form, and functions as an activity history. The form has some fields autofilled using linktoform(). It shares some field names with the first table, specifically, the container and quantity fields
I have gone as far as to be able to add new entries in the Activity History, but I haven’t found a way to update the quantity set by the user in both the Activity sheet and the first sheet.
Sheet one key is the container, sheet 2 key is row, but still has container field.
Is there anyway to store the latest quantity set through the form (which is adding rows in the activity sheet) in the first sheet, for the particular container/item?