Skip to main content
Question

Conditional drop down pulls up all child records

  • March 30, 2018
  • 0 replies
  • 27 views

Forum|alt.badge.img+9
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!
This topic has been closed for replies.

Forum|alt.badge.img+17
  • Quickbase Alumni
  • March 30, 2018
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?

Forum|alt.badge.img+9
  • Author
  • Quickbase Alumni
  • April 2, 2018
Hi Evan,
I currently have a conditional drop down that filters to the available quotes, but only one may be selected per Invoice request. 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?

Forum|alt.badge.img+9
  • Author
  • Quickbase Alumni
  • April 2, 2018
I think what I need to do is create a lookup to the report link.  Is this possible?