A
Abdul Wahab
Hi, I have searched for my problem, however, could not find it. 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.
Thank you
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.
Thank you