I have an existing database that the sales director would like modified. Currently to report on their meeting, the salespeople type in the company and contact name after a sales call. He would now like to have the Company Name and Contact field as a dialog list to make input easier and prevent typing errors. I have created a separate view within the database (COInfo) and populated with the existing contacts. I used the formula @Unique(@DbColumn(“”:“NoCache”; “”; “COInfo”; 1)) for the coname field as a formula. The formula is working; the names are displayed in the dialog list. But if I enter a name not currently on the list, it displays in the document but is not added to the dialog list. The COInfo view is based on a form that I used for input.
If I have not made myself fully clear, please post your questions. Any guidance would be greatly appreciated. Thank you.
Anita