How can I update a table's field when another...

(Mark Wilhelm) #1

How can I update a table’s field when another table’s trigger field is changed?

I have two tables - Components and StoresInventory, the components table consists of a master list of serial numbers of components. i want to scan the serial from the physical component, then add it into the StoresInventory table, then update the component table to have the stores name in the StoreName field.

(Aleksi Alkio) #2

The easiest way is with the virtual column.

(Mark Wilhelm) #3

hmm… interesting idea! could you please elaborate more…?

(Aleksi Alkio) #4

You need to lookup the value with the suitable app formula and because it’s in virtual column, it will recalculated when you sync the data. - Virtual Columns Virtual Columns