I want to be able to use address data base in all tables?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a database of addresses and now I am creating a database of
work dockets of jobs inprogress. On each docket I need the name, address etc
and phone numbers but I don't want to have to type them all over again. How
do I put a code that will just transport the information that I need from the
mailing addresses?
I seem to have tried everything. Doing lookup works for name but how do I
know which phone number belongs etc. I gave each name a codename could I
not just type that an all the information belonging to that code be
transfered?
 
Hi Queenie,

In Access a "database" is uaually an .mdb file and always contains one
or more tables which themselves contain the data. So it's not clear
whether you're talking about multiple databases or multiple tables.
Normally in a situation like yours there'd be one table for "customers"
and another for "jobs". Records in the "jobs" table would normally not
contain all the address information; instead there'd just be a "foreign
key" - like your codename - that Access uses to look up the address from
the "customers" table.

Take a look at the Northwind sample database that should be installed
with your copy of Access (it's probably somewhere like "C:\Program
Files\Microsoft Office\OFFICE10\SAMPLES\Northwind.mdb"). The Orders form
in Northwind has two sets of address fields: the billing address fields
are linked to the Customers table and can't be changed, while the
shipping address fields are in the Orders table so they can be changed
if necessary. The form gets its data from the query "Orders Qry", which
shows how to join the two tables.
 
Back
Top