Dynamic Reference column showing only records based on another reference column

aka dynamic drop-down lists.

I’ve been searching around, but seems it cannot be done yet. I have it setup like this in Access, but I’m not able to replicate it here. While I’m entering data in my Projects table, for the Client Company, I enter Company A, then when making a selection from the Client Groups, I would like the list to only shows the groups listed for Company A.

PROJECTS - Origin Table
Client Company - Reference
Client Group - Reference

Client Company:
Company A
Company B
Company C

Client Groups
Company A, Group 1
Company A, Group 2
Company B, Group 1

1 Like


There is a feature request for such a use case: Python formula to filter dropdown in reference columns · Issue #300 · gristlabs/grist-core · GitHub.