I haven’t been able to find this yet so obligatory apology if it’s elsewhere. I have a table that will serve as a place for users to enter a variety of inventory information (putaway table) I’d like a button that will take all rows and write them to the appropriate table in the correct place based on one of the pieces put in. SO, Example:
Putaway Table Header: Value
Locations Header: Value
Location: (Already has the location R-84)
Items: (Need to update this with SKU from the putaway table on the row that has R-84) (where Locations.location == Putaway.location)
Category (Update with data from putaway table on appropriate row (where Locations.location == Putaway.location)
I can’t get it to work on a single row, so we’ll start there, but I’d LOVE if I could set up a button that does it on each row in the putaway table.