Get values from another table (ID)

[Dega]

I have three bare bones tables with tblCustomer, tblBookings, tblTours.
Main form will be tblCustomers and sub forms tblBookings (datasheet).
More subforms will be added later.

In the bookings form I want to get the TourID FROM "TourName" in tblTours and enter it in the tblBookings table as a value and the combo box should not show the value but the TourName.

Table relationships are attached to posting.

Thanks


tblTours
TourID
TourName



(sample data)
1 Destination-ONE
2 Destination-TWO
3 Destination-THREE


tblCustomers
CustID
FirstName
LastName
DOB


tblBookings
BookingID
CustID
TourID

[pbaldy]

The combo box wizard should lead you through creating that. Presumably your form is bound to the bookings table.

[Dega]

I was able to get it working without using the wizard and the values enter correctly in the tblBookings.

But ... both the TourID and the TourName are showing in the combo box. I would like only the TourName to show in the combo box so is it the properties that I have to set?

Eventually other users will be using the db and you know the rest.

Thanks

[pbaldy]

Set the column width of that column to zero.