Hi Friends,I need a suggestion on a dialog list field. BAsically I have a dialog list field on a form it should show list of clients. The problem is that we have too many clients so we have designed a solution to show a field where users can select “A”, “B”, “C”…etc and based on what they select we calculate dialog lsit to show clients that start with “A”, “B” or “C”. The problem is that if a user selects “A”, the dialog list displays all clients starting with “A”, but if user changes his mind and selects “C”, the dialog list field is not showing clients with “C” it still show clients with “A”. In other words the dialog list field formula is not updating dynamically. How can we fix this? Any suggestion is greatly appreciated.
Thanks,
Vikram