Forum Discussion

MatthewMatthew2's avatar
MatthewMatthew2
Qrew Trainee
13 years ago

Formula to look up a corresponding field from a related table?

I'm a new QuickBase user. This is probably a simple question, but I don't know how to construct a formula to look up a corresponding field from a related table. I have a parent table and a child t...
Account and realm management
Forms
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Hmmm, so are you saying that the last six characters of the account number are in fact unique and in theory could be used as the Key field of the Account Record? Have you checked that they are unique or you just know they must be due to the natur if the data.