Okay, I've figured out how to change the textbox to a dropdown, but I can't populate it. I don't see a way to link it to a different masterfile to populate it from the database. I can set static values, but went I run it, it doesn't populate.
It's not clear what you're trying to do because you ask about InfoAssist and Maintain Stacks. Those two are mutually exclusive. InfoAssist generates Autoprompts for the unpopulated required variables. If you're trying to get a list of values in an autoprompt populated by the values in a file, you can either use the FIND fieldname IN file in your WHERE test or use JOIN and test for the value of the &variable in the cross reference file. Either way, Maintain stacks won't be a solution within InfoAssist.
WebFOCUS 8204, Unix, Windows
Posts: 1439 | Location: New York City | Registered: December 30, 2015
What I have figured out so far. First, the blue button with the arrows to the right of the very important "Selection to" box on the settings tab of your control does nothing except detach the "Requests & Data Sources" window from the workspace window and drop it someplace random on your screen. It's a complete red herring, there to confuse you (that which does not kill us, makes us strong). "Selection to" is the field that will be used to both set the display value of your control and the field your control will update. It seems to be set from the "Parameters" tab, except that it isn't. Untouched text boxes created by InfoAssist are linked to stack fields. You, on the other hand cannot (so far at least) do this. Drag your stack field to your control and it just links the stack as a whole (Useless!), but you will see the stack name appear in the "Selection to" box, so we're on the right track (maybe). You can also create controls from the parameter screen by right clicking on your stack and selecting "Create control for". A great feature of the create controls box is the Control Type column, which taunts you by making you think you have some choice. You don't. Nor do you have any choice where the control will appear on the screen. In my case, they appeared underneath a panel and were **** to find. Another neat feature is the way the stack is portrayed on the parameters screen, showing only the first four letters of the field name. If use some sort of hierarchical naming convention, as we do, the first four letters will all be the same. Stretching the box does no good.
So now I'm thinking I might be able to cut and past the control to place it on the panel, within the form, and I might be able to change the text box to a dropdown without losing that precious link to the stack field. I'm not optimistic though.