Child Reference field not pulling Parent key

Question

The reference field in my child table should populate with the parent table key field, but instead its pulling in data from a different random field from the parent table form.

Parent table has a form to log corporate threats/risks. Within each threat record, is an embedded report of incidents (from child table) with ability to add incidents. Each threat can have multiple incidents. Related Threat field (reference field) in child table should populate with Record ID# from parent record, but instead is populating with value from Responsible Department field in parent table.

Setup is below. Any help greatly appreciated. NOTE: I'm a Quickbase newbie and have no programming experience. Thank you!

child report within parent record:

Add new child record:

From parent record:

Report field settings within parent table:

Related threat field settings in child table:

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

markshnier__you · Answer

Can you post the code for Add Child Button and also what is the Field ID of the Related Threat field.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

dianesinawi1 · Answer

Hi Mark, thank you for your helpRelated Threat field ID is 23------------------------------Diane Sinawi------------------------------

markshnier__you · Answer

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
------------------------------

dianesinawi1 · Answer

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------------------------------

Forum Discussion

Child Reference field not pulling Parent key