Cascading Combos

A

ant1983

Hi,

I've posted a separate issue entitled: "If one value then fill out other
values" so you can refer to that if u want but here is a outline of my
problem: Basically what I want to do is depending on a value selected in my
first drop down box the possible options in my second drop down box should be
limited. My structure as follows:

First table is tblCompanyClient: (fields are)
- autCompanyClientID (Primary Key and Auto Number)
- txtCompanyName

2nd table is tblCompanyClientContact: (fields are)
- autCompanyClientContactID (Primary Key and Auto Number)
- numCompanyClientID (Lookup column from ABOVE)
- txtFirstName
- txtSurname

Then I have a query called qryCompanyClientContact where i added the
tblCompanyClientContact-table (my 2nd table above). I then added all those
fields (the 4 fields) and then added a 5th field called "FullName" (
FullName: Trim([txtFirstName] & " " & [txtSurname]) )

Right...

Now i have a form called tblBooking and the fields include:
- autBookingID (Primary Key and AutoNumber)
- dateDateOfBooking
- numCompanyClient (Lookup from 1st table ABOVE)
- txtBookedBy (Lookup from the query (qryCompanyClientContact) ABOVE as i
need the full name)
- txtContactNumber

Now i have a form called frmBooking and this is where the trouble starts...
Its a straight forward from that runs off the tblBooking table...

So, what do I do now? What seems to happen is the actual
“autCompanyClientContactID†instead of the persons name is the value in the
txtBookedBy field…

WHY?!?!?!??

Thanks all!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top