DropDown shows "X", but records "Y" in other field. (1 Viewer)

[brunces]

Friends,

I have a little problem here and I just don't know how to solve it.

I've got 3 tables:

Table1: CLIENTS
Field1: Client_Code (Autonum)
Field2: Client_Name
Etc.

Table2: CARS
Field1: Car_Code (Autonum)
Field2: Car_Plate
Etc.

Table3: RENTAL
Field1: Rental_Code (Autonum)
Field2: Rental_Client_Code
Field3: Rental_Car_Code
Etc.

In the form created for the RENTAL table, I've got a DropDown (Combination Box, linked to the CLIENTS table) to choose the client's NAME. When I choose a NAME, I want Access to record in Field2 (Rental_Client_Code) just the "code of the client" pertinent to that NAME, and not the NAME.

Same thing to the License Plate. In the form created for the RENTAL table, I've got a DropDown (Combination Box, linked to the CARS table) to choose the car's PLATE. When I choose a PLATE, I want Access to record in Field3 (Rental_Car_Code) just the "code of the car" pertinent to that PLATE, and not the PLATE.

If someone didn't understand the point, please, notify me... For I'm Brazilian and my Office is in Portuguese. Maybe I didn't write the correct translation for the things I want to know about.

If I made myself clear and someone can help me, I appreciate it very much.

Thanks for the attention.

Hugz.

Bruno Cesar
brunomag@ftml.net

 

[cpgospi]

Bruno,

I think I understand your question correctly...

The properties for your combo boxes should be set like this:

Column Count = 2
Bound Column = 1 (provided your 'code' fields are column 1 in the table/query)
Column Widths = 0; number big enough to hold Plate/Client Name


These properties will store the codes, yet display Client/Plate info.

HTH,


Chris

 

[brunces]

Chris,

It worked, my friend. Just like you told me to do.

I'm here to thank you so much for your attention.

Hugz.

Bruno

 

[cpgospi]

Great, glad it worked out!