Auto populating fields from another table

[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.

 

[Arvin Meyer MVP]

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.

 

[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?

 

[Arvin Meyer MVP]

First, DO Not use Lookup fields. They confuse filtering and create a poor
vision of how to store and display data.

http://www.mvps.org/access/lookupfields.htm

Actually, there is a wizard for combo boxes that will guide you through the
correct way of building them, just make sure the Toolbox wizards (the magic
wand) are turned on.

MVP, Crystal Long has great tutorials that may help you as well:

http://www.accessmvp.com/Strive4Peace/Index.htm