brunces
Registered User.
- Local time
- Today, 08:38
- Joined
- Sep 12, 2004
- Messages
- 45
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
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