Forum Discussion

MikeTamoush's avatar
MikeTamoush
Qrew Elite
3 years ago

Creative work around for conditional dropdown conundrum?

I have a table of Sites. Each site has many contracts.  Flash forward to a table of Projects. On my project I want to select a contract, and I want the sites to be shown conditionally, so that the...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago

You should be able to set the Condition that after selecting Related Site of the Contract 
only show Sites where Record ID matches. 



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
MikeTamoush's avatar
MikeTamoush
Qrew Elite
3 years ago

Oh I missed a step. A site has many contracts and a contract has many sites. So there is a many to many table in there.

So i could relate it to my SIte/Contracts (many to many table), but I would like to just select the contract, then site.



------------------------------
Mike Tamoush
------------------------------