Forum Discussion

BrittanyBrittan's avatar
BrittanyBrittan
Qrew Trainee
8 years ago

Show Field from Separate Table based on Corresponding Field

I have seen a few conversations about this, but am having a hard time relating the information back to my own app. I am looking for a way to pull a specific text field from a different table, based...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Is the Job# field unique in Table 1  ie can there be multiple table 1 records for a single job?
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
So a suggestion is to change the key field of table 1 to be the Job#.  Then make a relationship where 1 Table 1 has many Table 2 (even if there will only ever be 1 child).

Then you can look up any information from Table 1 down to Table 2, including its completion status.