Forum Discussion

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago

Re: Child Reference field not pulling Parent key

I think I know what is going on. I suggest that you check the set up in advance settings for the parent table and make sure that the record picker fields are appropriate. The first and perhaps only field you need for the record picker would be the threat.  My guess is that the record picker may have the department as the field which is being offered to the user to help them choose a threat.

The other thing you want to do in that relationship in the first screenshot is to do a look up of the name of the threat. Edit the field for related threat and set a proxy field for that field to be the name of the threat. I think if you do both those things everything will make sense.

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

1 Reply

Sort By
  • DianeSinawi1's avatar
    DianeSinawi1
    Qrew Member
    4 years ago
    You were correct - the record picker field was set to dept. I changed to Record ID, and the correct related threat ID# is now populating in Related Threat field when I add an incident.

    I'm not sure I need a proxy field, as all of us using this understand what Related Threat field should populate with and I can generate reports for incidents that include related threat number, which is fine. But I'll look into it.

    Thank you so much for your help!!!​

    ------------------------------
    Diane Sinawi
    ------------------------------