I'm not interested in only one field. Ok.. Combo box, the user selects ABC RV Center. Then the other fields associated with ABC RV CENTER gets filled in like ABC RV CENTER code number, and ABC RV CENTER REP_NO, and RV CENTER code number....
The "other" fields are from another table...
TO: GingerR
I'm sorry.. I will not post anymore. I will print your last e-mail and will try to figure this out based by the info that you provided. Thank you for being patient with me.
I bought a book that cost $54.00 and sometimes these books don't give the answers that I need. This forum is...
To GINGERR:
Thanks Ginger. This makes alot of sense. Now, once I create all these table how do I auto populate the DATA ENTRY table after the end user selects the DEALER NAME to autopopulate the DEALER CODE, STORE_NO, REP_NAME and REP_NO?
I'm not really sure whether to use VBA CODE or the...
TO: BOXHEAD
The DEALER NAMES are not unique. There may be a case where there are three of the same DEALER NAMES but with different STORE_NO and REP_NO and REP_NAME in each record.
To ToeShot:
This is just an "example" as posted in my original message. The DATA ENTRY table actually contains 35 fields. Instead of actually posting the entire data structure, I just wanted to convey only those fields that I want to auto populate.
Can you help?
Here is my two tables (exmples only)
TABLE NAME=DEALER CODES
DEALER NAME:
DEALER CODE:
STORE NUMBER:
REP_NAME
REP_NO
TABLE NAME=DATA ENTRY
DEALER NAME:
DEALER CODE:
STORE NUMBER:
REP_NAME
REP_NO
I would like the end user to Enter the Dealer Name in the Data Entry table by selecting the Dealer...
Here is my two tables (exmples only)
TABLE NAME=DEALER CODES
DEALER NAME:
DEALER CODE:
STORE NUMBER:
REP_NAME
REP_NO
TABLE NAME=DATA ENTRY
DEALER NAME:
DEALER CODE:
STORE NUMBER:
REP_NAME
REP_NO
I would like the end user to Enter the Dealer Name in the Data Entry table by selecting the Dealer...
I have two table as examples below:
DEALER_CODE DATA ENTRY
=========== ==========
DEALER_CODE DEALER_CODE
DEALER_NAME DEALER_NAME
REP_NAME REP_NAME <--Want auto populate with
REP_NAME in DEALER CODE table
when...
I have a table that consists of the following fields:<br>
Low Address Range Data example: 300<br>
High Address Range Data example: 900<br>
Street Name Data example: Main <br>
Street Suffix Data example: St<br>
ZipCode Data example: 75228<br>
City...
I have a table with the following fields: cities, zipcode and State. <br>
<br>
I would like to autofill the city and state whenever the zip code is entered within a data entry form. Can anyone help on how to do this?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.