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

[Guest]

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.

 

[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.