I have field that is used as a predecessor field that contains the Record ID of the predecessor record. I would like to create a field, or a color highlight of the predecessor field to show the status of that predecessor record.
Record ID 10 has predecessor of Record ID 5. I would like to display the Status Field of Record ID 5 on Record ID 10.
------------------------------
Nicholas Bellows
------------------------------
Question
Create Field to Show Status of Another Record in Database
+2This topic has been closed for replies.
+22If there is only going to be one predecessor per record, then you can make a formula Mirror field called [Predecessor Mirror] with a formula of
ToNumber([Predcessor])
Then make a relationship of the table to itself and use that as the reference field. Then lookup the status of the Predecessor record into the "successor" record.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
ToNumber([Predcessor])
Then make a relationship of the table to itself and use that as the reference field. Then lookup the status of the Predecessor record into the "successor" record.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.