access tables and relationship

[ion]

i have 3 tables with primary key of
Car_registrationNumber in tblstock
C_DrivingLicenseNumber in tblcustomer
S_ID in tblstaff

my linking table which connect all three table in one to many relationship
is tblhire

my problem is this]

in my tblhire i have three fields which are the three primary keys at the top
when i click on the C_DrivingLicenseNumber primary key it shows me the
customer driving licnse number and first name and surname
but when i click on the Car_registrationNumber it only shows me the Car
registration Number not the car make and model

why

to be more clear have a look at this screenshot i took and uploaded
here is the link

http://www.box.net/shared/5zmovt5e8t

 

[Ron2006]

Assuming that the query that is used for the combobox includes all
three fields.
Look at the format tab of the combobox properties.

The number of columns should say 3 (at least)

The column width for each of those fields needs to be greater than 0.

Ron