Forum Discussion
JohnRogers3
7 years agoQrew Trainee
Instead of changing it by automation, why not change the field in one of the tables to a lookup field to match the status of the other. So at all times the statuses will match? Would this not fix your problem?
JohnRogers3
7 years agoQrew Trainee
Sorry for late response, when making a field the very last field type should be a lookup field.
Careful changing field types because it will delete all stored data connected to the previous field data type. I would recommend creating an entirely new field just for testing, make it a lookup field.
Another way to do this,
Table 1: Field 1 = testField //this is a text field
Table 2: Field 2 = testField2 //this is the lookup field which is a formula text
now in the formula text you just put in [testField]
this will import whatever is in testField and display it in testField2
Careful changing field types because it will delete all stored data connected to the previous field data type. I would recommend creating an entirely new field just for testing, make it a lookup field.
Another way to do this,
Table 1: Field 1 = testField //this is a text field
Table 2: Field 2 = testField2 //this is the lookup field which is a formula text
now in the formula text you just put in [testField]
this will import whatever is in testField and display it in testField2