Skip to main content
Question

Choosing a parent from a child table

  • Jan 16, 2026 7:03 PM UTC
  • 2 replies
  • 152 views

Forum|alt.badge.img+8

My parent table is "Change Requests" and child table is "Prompts." The prompts tables houses prompts to a chatbot and the Change requests table houses all change requests (bugs found, knowledgebase expansion etc) that stem from prompts that have a negative feedback.

So each prompt could have a change request. I created a Related Change request numeric reference  to link the two tables and a corresponding Change Request (Text (reference proxy) ) and this allows me to look up and choose a parent record to assign the child to.

However, I first need to create the parent record before it shows in the drop down menu of the Change Request (Text (reference proxy)) field. Further, I would like to filter this drop down to only show Change requests related to that particular Bot (as the Prompt table houses data for multiple Bots).

  1. Is there a way to create a new 'Change Requests' record from within the Prompt's table?
  2. I have Prompts collected for two Bots - Is it possible to filter the Change Requests drop down in the Prompts record to only show the Change requests related to that particular bot?

Thanks!

Deepa

 

2 replies

JeffRichey47779
Forum|alt.badge.img+4

Hi Deepa,

Based on what you have described here, it seems like you might have more success if you reverse the relationship so that the Prompt is the parent of Change Requests. Is that possible or do you have other technical considerations that are forcing you to use an existing relationship?

Jeff Richey | Solutions Consultant
Website | LinkedIn | Knowledge Base


Top Step
Forum|alt.badge.img+12
  • Observing
  • Oct 17, 2026 6:32 PM UTC

You can keep Change Requests as the parent. Both things work with your current setup.

To create a Change Request from the Prompt, open the Change Request dropdown on the Prompt form and choose Create a new record (the wording changes to match your record name). Fill in the change request and save, and it lands in the dropdown on the prompt. You need add permission on Change Requests for this, and it won't work if that permission comes from a group.

Filtering by Bot is a conditional dropdown. You need a Bots table that's the parent of both Prompts and Change Requests, so each record has its own Bot field.

Then open the properties of the Change Request reference field on the Prompts table and turn on "The values in this field depend on a selection in another field." Set it so Change Requests are filtered where their Bot matches the prompt's Bot. Use the Bot name proxy fields in those dropdowns, not the record ID fields.

After that, the picker on a prompt only lists change requests for that prompt's bot.

https://help.quickbase.com/docs/adding-parent-records-from-within-child-records

https://help.quickbase.com/docs/conditional-dropdowns

https://help.quickbase.com/docs/conditional-dropdowns-basic-setup