Forum Discussion

MichaelGraham2's avatar
MichaelGraham2
Qrew Assistant Captain
9 years ago

Find a field in last record of a table and show it on any record.

We have a system where the key field is not the record ID and also the data we have inherited is not sequencial. At the moment to create a new record they are guessing a number and if it is not used t...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
9 years ago
You make a relationship where 1 Max record ID# has many Components.  

But rather than accept QuickBase's suggestion to make a new field for you, when you make that relationships select that field that calculates to 1 as the reference field on the right side of the relationship.