How to populate multiple fields

[HIVOLTG]

I have records that have the following fields. jobnum, firstname, lastname,
address, phone. We perform multiple jobs for the same customers. The same job
number is used on multiple jobs for the same customer (the receord numbers
are different). I want to be able to populate the firstname, lastname,
address and phone fields when I enter the job number. I am using Access2003.
Can you help?

 

[tina]

storing data redundantly (same customer info in multiple records) violates
data normalization principles. generally speaking (since the posted table
details are sparse), you should have a table that describes customers -
firstname, lastname, streetaddress, city, state, zip, phonenumber, *and* a
primary key field to uniquely identify each customer; this could be an
Autonumber field. in each job record, you would store only the primary key
value of the relevant customer; in the jobs table, this would be called a
foreign key field. the result is that each customer's data is stored only
once, but can easily be "matched" to the customer's job record(s).

hth

 

[HIVOLTG]

Good point Tina. I will make the necessary adjustments. I should only need to
create the customer table and have the records in that table populated when
customer information is entered into the "add work order" form. You have been
a great help!