Conditional drop down pulls up all child records

Question

I have a conditional drop down within Invoice requests that displays the quotes associated with a project.

Projects<Quotes
Projects<Invoice Requests
Quotes<Invoice Requests

Currently an invoice request is associated with just 1 quote. I have been asked if 1 invoice request can include all quotes associated with a project. I am not sure how to set this up. Is there a way to pull all of the child quote records with the selection of the Parent "Project"?

Thanks!

evanmartinez · Answer

Hi Christine,I just want to clarify are you wanting to select your Project on the Invoice Request table and then have the list of related Quotes show only the Quotes that belong to this project? Then from this list you would still at the end select only 1 Quote to be the parent of your Invoice Request?

christinewhite · Answer

Hi Evan,I currently have a conditional drop down that filters to the available quotes, but only one may be selected per Invoice request.&nbsp;I would like to allow users to have the option of selecting 1-all quotes to invoice per request, possibly displaying all available in a child table?

christinewhite · Answer

I think what I need to do is create a lookup to the report link.&nbsp; Is this possible?

christinewhite · Answer

Working on this idea now, I changed the default report link to must match the Project.&nbsp; I think this will work

christinewhite · Answer

Seems to work.&nbsp; thx!

Forum Discussion

Conditional drop down pulls up all child records

Related Content

Lookup Field not pulling Data

How to Pull Employee Name and Title Instead of Record ID Number in Quickbase Pipeline

Lookup Field Not Pulling Data

Conditional formula url

Custom Record Titles