Forum Discussion

20496's avatar
20496
Qrew Member
2 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
Qrew Champion
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)
mark.shnier@gmail.com
------------------------------
20496's avatar
20496
Qrew Member
2 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.  
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    2 years ago
    The form either needs to have the field for Related Service on the form or else whichever field that Related Service has set in its field properties to be its "Proxy" field.

    The advantage of a Proxy field is that the users will not have to see a meaningless number as a link back to the Parent Service record.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------