why no one want to help .....

[tarek_ta2ta2]

i sent my problems many times and no one try to really help

i need this very urgent ... please my job depend on it

i upload my Database (Access 2007)

as i explain before

i just want to test values the user chooses it from combo boxes to values exist in atable so if there's a match make a special record appear from this table

In More Details
i have the followin combo boxes
make - model - grade - year - kilometer - transmission - engine size

and every combo box is load its values from a table
tblMake - tblModel - tblGrade - tblYears ... and so on

and i made the models load value according to the make it works well

and i create a table contains all the data included the price (tblAll)

so what i want is to match the values in the combo boxes to the values in the tblAll so if there's a match make the record which contain the price appear

please ..... help

 

[georgedwilkinson]

Banana's "how to get help"
http://access-programmers.co.uk/forums/showthread.php?p=705111#post705111

A link from the administrator (from http://www.access-programmers.co.uk/forums/showthread.php?t=85042):
http://www.catb.org/~esr/faqs/smart-questions.html

It's all a matter of time and priorities. I spend time on questions I understand that might be fun to answer and I always take into account the risk/reward ratio. I can't speak for the other volunteers here, but I imagine they are under some of the same constraints.

I barely ever look at posts where the subject line is begging for help.

HTH get your answers.

 

[khawar]

If possible upload it again in Access 2003 format I dont have 2007

Khawar

 

[tarek_ta2ta2]

Database in 2003

ok .. i uploaded it in 2003 format

thanks.

 

[khawar]

First of all you structured is not normalised at all

Why are you maintaining seperate tables for toyota and BMW you should have one table with one extra column named category or make

What if you or your company starts dealing in some another make think of revising your structure

I was not able to understand why are you using engine size twice on form

You were also using make as primary key for table tblAll which will never allow you to add the name toyota more than once and thats the reason you used the different spells for toyota (toytoa) in the secong record i added an id field as primary key ammend it according to your needs

Any how for now i am posting the solution to your problem but still advise you of revising your structure structure you are going to use currently is not relieable at all i dont advise you to use it i am just giving you the answer to show how to do it but dont use this structure at all

Creat relations properly enforce referential integerity (for example check the speeling of automatic in tblAll this would not have happened if proper relationships were enforced

Select your criteria on form test and click price button to show matching record from the query results

Regards

Khawar

 

[khawar]

I think i have some problem attaching the file will try again at night sorry i have just seen that attachment is not there and tried again but it has some problem

Khawar

 

[tarek_ta2ta2]

one tabel against many tables

thnaks for your advise and help

what i get from ur explain about the structure that

you want me to put the make and models all in one table

but if i do that how i will make the models table reflet the make models
EX: when choose toyota the model combo box reflect toytoa models

i can only do this by make table for every make models ( bmw models - toyota models ) so i can say if the user select toyota from the make load the table contain the models from the toyota models table

 

[khawar]

Its attached finally and you have to use one table for all makes i still say

If i got time today i will send you ammended database the way it should be

Regards

Khawar

 

[khawar]

Confirm me if this is the solution you wanted

Khawar

 

[tarek_ta2ta2]

first .... really my words can't thanks you enough

second .. it's very near to what i want

when the user press button price i want the record of the price from the tblall appear in the from in atext box or something like this not to open the query

i also wanna say sorry for my stupidity i work as flash developer and i never thought it will be that difficult in access

sorry for all the troubles .. really so shamed

 

[tarek_ta2ta2]

correct the mistakes

it will be very kind of you if you make any modification