Auto populating fields from another table

  • Thread starter Thread starter LG
  • Start date Start date
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.
 
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.
Click to expand...

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.
 
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?
 
Back
Top