> *Is there a way to have a field on an input screen provide a drop down list to select from another database?
>
> The best way is via .input field statements on a report form; actually I've renamed it an inport form [combo of input and report] as there's much more flexibility and options by making doing your input in the Report form module because the dropdown list can be made mouseable in a the report module using dot commands.
>
> But let's for this purpose limit it to the Input form since that's what you're talking about... if the dropdown list is fixed [or even if it changes, but that will require periodic manual updating], make it into a menu. So you're drop down list is basically a menu of choices. We'll call the menu DROPDOWN.MNU but you can name it anything. Say the input field is HIHO. So when you do you're PUT IT HERE routine via Shift/F9 on the Add screen, you might further define it by saying YES, it does have a macro procedure and do something like...
>
> Enter Shift/F9 macro : {Do Menu}DROPDOWN.MNU~
> Enter prefield macro : {Send} (S) * Shift/F9 For A Menu Of Choices *~
>
> or if you wanted it to pop automatically, you could simply skip the Shift/F9 field and put the Do Menu statement in the prefield macro and it would pop when the cursor lands in that field. Inside the menu you would just write whatever it is you want to land in the current field followed by a tilde {~} to move the cursor to the next field. Just make sure the entered information is at least one space shorter than the length of the PUT-IT-HERE field otherwise the last character will overwrite previous character. /OAfurf*