RE: Displaying a result based on user selection

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Emma,

I think what you will need to do here is a Double Lookup. Follow the
following link to Chip Pearson's web page. He gives a great example of a
double lookup.

http://www.cpearson.com/Excel/TablesAndLookups.aspx

Please press Yes if this helped you.

John

"Emma" wrote:

I need to display a result based on what a user selects from a list of options.

Example:

Selection A - Make of car
Mazda
Ford
GMC
Porshe
Toyota

Selection B - Number of Doors
2
4
5

Result possibilities:
If the user selects Ford and 2 door then the result would come up with an
F-150.
If the user selects Mazda and 5 door then the result would come up with a
Mazda 3.
etc.

How do I do this. I can create drop down lists and list boxes, or control
boxes to show the Selection A & B however I don't know how to get it to
display the results based on the selection.

Thanks for your help!

.

Relevant Pages

  • Re: Displaying a result based on user selection
    ... See Debra Dalgeish's site for instructions for creating dependent DV lists. ... Selection B - Number of Doors ... If the user selects Ford and 2 door then the result would come up with an ... I can create drop down lists and list boxes, ...
    (microsoft.public.excel.misc)
  • Re: serial numbers
    ... I want to put these items in a drop-down field were users select the item on input, say item "A" needs to be added to the database. ... The other thing also is that on creation of a new record these serial number values do not increase automatically but only for the value linked to the Item selection. ... select the item, use a second field Item_SN to lookup the item serial number from the table containing the unique items. ...
    (comp.databases.filemaker)
  • Wire up a ComboBox.
    ... How do I wire up ComboBox to my data table to store my selection and to my lookup table that allows me to make that selection: ... DataBindings configuration properties of the ComboBox ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: lookup databinding combobox using stored procedures
    ... data table or something of that nature, and then bind the drop down list to ... table that has its own ID field, the ID field from the lookup table, and ... DELETE commands have been set to the stored procedures and I can call them ... OtherDataTable the combo box must display the appropreate selection. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Lookup Table Field Retrieval / Separating Databases
    ... lookup tables are essential to a smoothly-running ... wish for the user to enter general Physical and Performance data such as ... I cannot understand why the actual selection in the combo box ... clients, and I want to keep the data for each client completely separate. ...
    (microsoft.public.access.gettingstarted)