Please Help .. .... make Value appear according to conditions

[tarek_ta2ta2]

i have 4 Combo boxes

1- make
2- model
3- transmission
4- year

the user choose values from this combo boxes
EX. Toyota - corrola - Manual - 2005

so what i wanna do is make a button when the user push it after selecting all values compare this values to values stores in another table so if the values is matched make the last cell value in this table appear ( which will be the price)

is it possible or i just dream.....

 

[doco]

i have 4 Combo boxes

1- make
2- model
3- transmission
4- year

the user choose values from this combo boxes
EX. Toyota - corrola - Manual - 2005

so what i wanna do is make a button when the user push it after selecting all values compare this values to values stores in another table so if the values is matched make the last cell value in this table appear ( which will be the price)

is it possible or i just dream.....

How do you know what the price is in advance? Do you have a scoring system for all possible selections? Whatever you use to determine price should be the key to showing the price.

Unless of course I have completely misunderstood the question

 

[tarek_ta2ta2]

i Hope i explain more

i have a table contains all the information

Make - Model - Grade - Kilo Meter - Price

and have many other table so the user select the value from it

i want when the user select all teh valus from the combo boxes

compare this valus to the values in the table which contain all this valus and if there's a match make a special record which will be the price to appear i hope i'm clear no

i will send my database if needed

 

[doco]

Hmmm...

What happens if a user selects Make = Toyota; Model = Accord? I am guessing you have some design flaws. It seems for instance, there may be a sliding scale of price dependent upon various conditions(?) and you have a field in a table for price. This should be a calculation I would think. But again it is hard to tell.

Are you using Kelly Blue Book for pricing?

I would think you would have a table that had all the possible makes and models, then a table with all the possible tranny choices. Then make adjustments based on a table updated from the Kelly Blue Book, for instance. But price should be a calculation based on BasePrice * ( TrannyFactor * MileageFactor * AgeFactor * WhateverFactor )

 

[DCrake]

Simple Software Solutions

Have a look at this image and see if this is what you are looking for

 

[Dee Cee]

I have seen the DB that you currently have in another thread. You are pretty much set up for this already. You need to create a query that gets its parameters from your main form. In the query design view, in the criteria box for each category you want you need to put:

[Forms]![FormName]![NameOfControl] eg this could be
[Forms]![MainForm]![CarMake]

This will force the user to look all the way down and (imho) it is too specific for everyone. They may just be looking for a make and model and want to see what is on offer. To do this you will be required to allow null values aswell. This would look like

[Forms]![MainForm]![CarModel] OR LIKE [Forms]![MainForm]![CarModel] IS NULL

The way to make it appear in your main form would be to create a subform that looked at the query. So when you press the search button on the main form it gave the focus to the subform. The subform can sit there permanently if you like and would initially return no results unless you allowed for nulls all the way through. Once run it would show all possible cars the user had searched for. If you allowed for nulls in all criteria except for Make the user would be able to, for example, search for all Hondas, all Honda Accords or any other combination.

The easyiest way to show you what I mean is to go onto www.autotrader.co.uk and look at how they have things set up. It can be as simple or as complex as the user wishes to be. But most will just want to look for a particular make and model and see what is on offer.

i hope this all makes sense to you.