I have 2 drop-down lists, both get data from database.
1st list is Name
2nd list is Vessel
I can get ‘when Name is selected, Vessel is auto-filled’
& When Vessel is selected, Name is auto-filled’
. However, I can only get this when only one rule is place.
Issue. When both rules are in place i get the “infinite loop” error.
Q- How do I get past this error. I want to be able to select 'Name which auto-fills 'Vessel, but if I don’t know the 'Name, I want to be able to select 'Vessel which auto-fills 'Name.
Is it to do with the conditioning?
Any help is appreciated.