AnsweredAssumed Answered

Relational Database working only for ONE entry

Question asked by mefxn on Jun 15, 2018
Latest reply on Jun 15, 2018 by mefxn



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)

Screen Shot 2018-06-15 at 2.05.40 PM.png



Within this, I've also nested another set of presets (Nested)


Screen Shot 2018-06-15 at 2.04.45 PM.png


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...