Conditional Value Lists with global fields
In a database I have recently created I am using a conditional pop up menu, based on a list in another table - and it's working great.
I created two global fields and tried to turn these into a conditional drop down menu, but the second menu won't adjust after the first menu is selected.
Is it possible to use global fields for this purpose - or am I doing something wrong?
I'm trying to set a value in the global fields, then click a button to apply the values to selected fields. Not sure if there is another way to go about doing this...?
Thanks for your help!