Navigator button to prompt field choices

[JoseQuiervo]

On my navigator I would like a button to create a new document. However, what I want is for the user to click this button, it prompts them to choose what TelevisionType(primary field on the document) Sony, Phillips, or RCA, and based on that choice determines how the document is created.

There's a single document that contains all the necessary data for each brand, but depending on their choice determines what data shows (via hide whens). How can I do this?

 

[pmonett]

You could use a formula in the QueryOpen event that asks the question, and make the fields in the document take their values as result of the question.

Pascal.

 

[ABOzIT]

Another way is to put the following formula into the default value of your TelevisionType field:

@Prompt([OKCANCELLIST];"Specify Type";"Please specify the type of television";"";TelevisionTypes)

Make sure you have all the different types in the TelevisionTypes field and make it a Dialog List. The list values for the prompt are obtained from this field. The best way to get the values for this field is via a profile document. This way if your brands change you just change the profile document saving you having to recode the field. Heve a look in designer help for info on Profile Documents. They are a very handy and often overlooked tool

Hope this helps!