Forum Discussion

DanaHauser's avatar
DanaHauser
Qrew Cadet
6 years ago

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...
Relationships
DonLarson's avatar
DonLarson
Qrew Elite
6 years ago
Dana,

Your business case is missing and that might really impact the solution.

Lets assume you have Projects and Project Managers.   You want all Projects to know the email address of the Project Manager where the Record ID# is 100

Create a Formula Numeric field Related Master Project Manager in Projects and set the value to 100
Now every Project has that as a value of 100

Now create a second relationship between Project Manager and Projects
Make sure you pick Related Master Project Manager as the Reference Field.  Do NOT let it create Related Project Manager. 

Here is your ERD


That will get the Master Email into every Project.  When you edit Record ID# 100 every Project will change.

This might not support the rest of your business case for work flow and reporting but gets the data there.



------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------