cascading issue

[looneytunes]

Hi,I shall be grateful for any help.

My problem

Tables:
Cars
Customer
Invoice
TblMake
Tbl Model

I have used cascading combos for Make and Model. They work fine. I have set up tblMake as follows:
ID
Make
I have make tblModel as follows:
ID
Make
Model
I use these cascading combos on a form. The data from this form goes into the "Cars" table. I have set the "Column Bound", "Width" etc. to show the name of the car, not the number.
However, I have created a search form. This uses a SELECT...... case in the Row Source. The details of each car are shown in a unbound listbox. This select case is supposed to show "Make" and "Model", which it does, however - they are numbers!!!
Please can anyone let me know how to change it so it shows the actual names of the car.
kind regards, looneytunes

 

[looneytunes]

hi, thanks for your reply.
when i tried to create a union query, it asked me for some SQL code. if anyone can advise me as to what i should put in, i shall be grateful - as i have never used a union query before.
thank you

 

[looneytunes]

hi Pat, thats great. the search form now shows the actual names.
however, there is one more problem

I used to be able to search using "Make" or "Model" or "Colour" or all of them - but with this JOIN query, I can only search for "Make". If I try and search for "MODEL" it makes me have to enter both details in. Is there any way to get around this.

p.s. I have set the record source for the textbox to the JOIN query. In this query I have this entered in the "MAke" criteria:
Forms!FrmSearchNew!cmbMake

As I said, it works fine for the "Make", but if I do the same thing for the "Model" - it wants both - and cannot work with just the "Make"
Thank you very much

 

[looneytunes]

thanks for ur reply - however, i do not think that is what i need.

my cascading combos work fine. however, i want to be able to do a search on "make" or "make" and "model". I have an unbound textbox which is requeried after a selection is made.
however, now that i have a JOIN query, the record source is that query. it only allows me to search for "make" and "model". if i search for "make" it shows nothing in the textbox, however, after "model" has been inputted - it shows relevant cars.
i hope it makes sense
sorry 4 being a pain!

 

[looneytunes]

its ok - got it sorted.
thanks for your help Pat