How do you use anything besides text boxes with Info Assist? Can it even be manually wired in JavaScript? I could take control of the click event and then set the stack value through Javascript, but I don't know how to access a maintain stack through Javascript. So I'm blocked both ways. I can't link the control through maintain and I can't find the stack with Javascript.

This message has been edited. Last edited by: mbondr,

Mbondr

Are these for autoprompting parameter values?

No. I need to allow the user to set a column value from a dropdown list, thus limiting their possible selections of input to a set list that is kept in a table. The standard scenario.

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.

I'm sorry to hear that this is an issue and am looking forward to the resolution. Please post that.
Thanks, Doug

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.

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.

One problem with this forum is that you can't post objects. I'm getting wonderful little Word doc examples that I would love to share, but I can't!!

quote:

One problem with this forum is that you can't post objects. I'm getting wonderful little Word doc examples that I would love to share, but I can't!!

You can save them to 'The Web' and post a link to them... Can't you?