I'm trying to setup preset options for a form, so when one field is selected in the drop-down, the other look-up fields will be auto-populated (Main)
Within this, I've also nested another set of presets (Nested)
Such that when Image Use within Main is changed, File Dimension, Photography of Bottle etc. will change according to the Nested presets
only ONE of the Nested preset works on the Main and I'm not sure why (I initial a new record to test all the presets and none of the look-up will work except for one and all fields update immediately without refreshing / relookup).
I've double check the look ups and even did an entirely new layout with new fields and setup the lookup the same way and it works as expected...only when I'm back to the Main presets that the connection broke.
I'm a bit fuzzy on the self-join concept and whether it's needed here but the test layout works without a self-join...