Forum Discussion

ilyailya's avatar
ilyailya
Qrew Trainee
7 years ago

how to get information from the dependent table into general table, similar Excel Vlookup

Hello, I have 2 tables in my App, 1st is the general one, which should contain all statuses from the second table. In both that tables I have equal ID numbers as a key.  How I can connected t...
Relationships
Tables and fields
JohnRogers3's avatar
JohnRogers3
Qrew Trainee
7 years ago
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?
ilyailya's avatar
ilyailya
Qrew Trainee
7 years ago
thank you.