Show field value from specific record
Hi, Is there a way to show the field value for a specific record ID on another table using a formula field? The tables are related, but it's not a related record. It's a specific record on ano...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp,
I will assume that this Parent table has a Key field of the usual Record ID#.
Make another relationship where say 1 staff member has many detail records. Let the system create a field for you and initially it may be called like [Related Staff Member 2].
edit that field's properties and change the name to be
[Record ID# of a specific person in a specific role] // think of a better name
Change the field type to be a formula numeric.
Look at the Staff member table and see what the Record ID is for this special person. say its 123
Make the formula for that field be
123
Then lookup whatever details you need from that Staff member record down to your detail records.
If Ms. 123 ever changes as the special person, then just edit that formula field to be the new special person's Record ID.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
I will assume that this Parent table has a Key field of the usual Record ID#.
Make another relationship where say 1 staff member has many detail records. Let the system create a field for you and initially it may be called like [Related Staff Member 2].
edit that field's properties and change the name to be
[Record ID# of a specific person in a specific role] // think of a better name
Change the field type to be a formula numeric.
Look at the Staff member table and see what the Record ID is for this special person. say its 123
Make the formula for that field be
123
Then lookup whatever details you need from that Staff member record down to your detail records.
If Ms. 123 ever changes as the special person, then just edit that formula field to be the new special person's Record ID.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------