Auto populating fields from another table

L

LG

I have 2 tables built. I have built a form so that you can add to it daily.
One of the fields in the form needs to link to another table so it auto
populates. Ex. the fields in the form are Member, id, address, phone, etc
there is another field for reason and there is another table with associated
#'s that correspond to that reason code. How am i able to have them enter
the number say 2 and it auto populates in the form field with only the reason
and not the number as well.
 
A

Arvin Meyer MVP

LG said:
I have 2 tables built. I have built a form so that you can add to it
daily.
One of the fields in the form needs to link to another table so it auto
populates. Ex. the fields in the form are Member, id, address, phone, etc
there is another field for reason and there is another table with
associated
#'s that correspond to that reason code. How am i able to have them enter
the number say 2 and it auto populates in the form field with only the
reason
and not the number as well.

Using a Combobox with the Reason Number being stored and the Reason only
showing in Combo (not actually stored) is the correct method of storing
data. NEVER store the text. That is the way a relational database should
work. A query, joining the 2 tables on the Reason Number will be sufficient
to display the text for reporting, etc.
 
L

LG

I am sorry I get the concept but don't know where to start or if I need to
start over again. D
Can you provide a little step by step guidance?
 

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