Automated "cells"

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

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically enter values in fields in a table 1
Populate 'To' recipient on custom mail form 0
Create New Table/Column 1
Excel, assign cells in multiple worksheets from one sheet 1
VBA to automatically cut, paste entire row based on date input and delete row 0
Reference sheets named by DAY 7
Excel Is this possible?? 3
Excel If a Cell Contains a Certain Text (From Another Table) 0

Back
Top