Forum Discussion

KatyKaty's avatar
KatyKaty
Qrew Trainee
9 years ago

Can I create a field which looks up data from another record within the same table?

Hi there,  I'm new to this so bear with me.... I have a table for "Supplies", and a table for "Tariffs". Each supply can have many tariffs (but only one is "live" at any given time).  Is there a w...
Relationships
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
9 years ago
Katy,

QuickBase allows a table to be related to itself.  So just set up that relationships and you will be able to chose your previous supplier and get any lookup values from the previous record.  The only trick part is really in naming the fields so it is clear to yourself and the user when they are selecting when they choose the previous Tariff.  QuickBase will give a name like [Related Tariff] that you will need to rename.