Populating data from one table into another when a check box is tr

T

Terry Wall

Hello,
I am trying to get a db that requires each contact to have a company
attached in order to generate an invoice to populate the company info fields
with contact info by adding a check box on the company tab. My thoughts were
that I could somehow retrieve from a query the contact info I need and update
the company info, however, I was wondering if there is a way without breaking
the cardinal rule of never "Duplicating Data" to populate the needed company
name and address which subsequently gets used in other areas of the db. I'm
thinking that I would not mind the extra data, but I don't want to be messy
and start learning to work with Access (I'm new) in an unorthodox "unclean"
manner.
 
R

ruralguy via AccessMonster.com

You do not need all of the Company information in more than one table. All
you need is the CompanyID (hopefully an AutoNumber) in the other tables. It
is then trivial to include the Company information in any table that has the
CompanyID as ForeignKey in the table using a query and a join.
 

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

Data entry for a table from a form 2
Populate fields in one table from another tables using pop up form 5
Populate Word Combo Box from Excel 2
Combo Box with lookup to one table, saving to another? 2
Data entry for a table from a form 1
Copy row data from one sheet to one or more sheets depending on numberof tick boxes selected (in the 3
Open another form if field checked in one form 1
populate form fields based on combo box selection 1

Top