I have a few screenshots that show the problem. Click on the 'SHOT's to see them.
SHOT 1 shows when I selected for a certain field where I need a drop-down box pre-filled with lookup values. No problem here
SHOT 2 shows how the Lookup Wizard morphed what I entered, when I closed the wizard then reopened it to enter a change. I am not getting the results I expected when I build the application. When I try making edits to this lookup wizard, it keeps distorting and changing what I enter.
SHOT 3 Besides linking through the right fields to the lookup table, I need to include a WHERE clause in the SQL used by the lookup wizard, because I need to prefill the drop down box with only some of the values in the lookup table. It seems like entering the SQL here should support that. In fact, I have had SOME success, but when I try saving the ASPR project file, then going back to edit it, it is as if the project gets corrupted and I cannot find a way to fix it, without starting over again from scratch.
Any information to help get past these issues will be immensely valuable to my company.
Thank you in advance for your kind attention to this matter.
Best regards,
Dan Allen
Montpelier, VT
