Automated "cells"

H

HoganD87

Stay with me....

(Sheet A) I have a table with the fields customer name fax and email that is
blank

(Sheet B) In a seperate table I've made a list of customers names faxes and
emails of every customer we use.

When I enter in the name of a customer in sheet A, I would like the rest of
the information for the other cells to automatically fill in with its
coinciding information.

And I know their not cells, I just came from excel and I'm new in Access
 
D

Douglas J. Steele

You're going to have to overcome your Excel background!

There's no reason for two separate tables. Have one table, and create a
query that return all rows from the table that have Null for fax and/or
e-mail.
 
Top