Forum Discussion

20496's avatar
20496
Qrew Member
4 years ago

Related fields showing in forms from different table

I'm trying to get a field from one table to show up on a form from another table.  I set up the relationship but it must not be right.  The wording for the field shows up but not the content of the fi...
Relationships
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
The field where you chose the parent is [Related Service] which is just a Record ID# so its not user friendly.  You have with deliberately or accidentally set the field properties for Related Service to be the Client Name.

So add the field for [Service - Client name] to the form and then you will be able to select a service record.

If the Client Name is not the best field for users to be using to select a service record then change your proxy field setting on the [Related Service] field to be a different lookup field.


------------------------------
Mark Shnier (YQC)
[email protected]
------------------------------
20496's avatar
20496
Qrew Member
4 years ago
I did add the Service-Client name and this is what shows now.

I have another relationship where the manager shows up so I tried to duplicate it.

Other relationship where Manager is viewable

My new relationship.
I did not build these to start with but I noticed that the previous person used the record ID a lot.  But if this doesn't work I will try something else.