Hi all, Is it possible to restrict the dropdown lists within a form based on other selections?
For example, if there are 3 tables where table 2 has a ref column to table 1. Table 3 then has a ref to table 1 and 2, so that in the input form for table 3, there is a dropdown selection for the ref to table 1, then based on that selection, the dropdown list for the ref to table 2 is restricted.
I’ve tried a few things but can’t get this to work. Is this possible?