Need help with pulling data from one table to autopopulate another

  • Thread starter Thread starter TanyaM
  • Start date Start date
T

TanyaM

I have two tables:
1. Company - contains informaton specific to a company
2. Individual - contains information specific to an individual, who works
for one of the companys in table 1.

I want to have it set up so when you choose (from a pulldown - list is
selected from table 1) a company in the individual table (table 2) - based on
the company selected I want it to autopoulate the address field (in table 2)
with the address information (from table 1).

Any help I really appreciated.
 
First, it appears that you're using a lookup field
(combo box) in your table, which is generally not
a good idea. For more on the subject see;

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

Second, you should not store the same data
redundantly in two different tables. You should be
using a form for data entry/editing. In the form you
can *display* (not store) the address from the
Company table by using an unbound text box that
uses DLookup or gets the value by using the column
property of a combo box, etc. You can find info on these
methods in Access help, or you can post back here
if you have questions.
 
Back
Top