moving information from one table to another

[Guest]

I have created two tables in one DB and they contain certain fields that are
the same. I don't want to have to enter the information twice. How would I
be able to enter information in one table and have it automatically enter the
information into another table? These two table "track" different
information on these similar fields so that is why there are two different
tables.

I am sure if I did enough searching through help, but I don't have the
patience or time so if any one can give me any helpful information, it would
be GREATLY appreciated. Thanks so much!

 

[Jeff Boyce]

Jamie

This sounds suspiciously like ... a spreadsheet! I can imagine situations
in which you'd pretty much have to copy stuff in one spreadsheet into
another.

But Access is a relational database. You won't get good use of Access'
relationally-oriented features/functions if you insist on feeding it 'sheet
data.

Since everything starts with the data in Access, please provide a more
specific description, so folks here can offer more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Jeff is correct. But, I do want to a a little further with info that may be
helpful.

If you have a set of data that are used by by two different entities, there
are a couple of options that you can consider.
One would be to merge both of your tables into one.
The other, if merging to one will not work for you, is to remove the common
data from the two and put it into a 3rd table. Without enough detail, I
can't see exactly how you would set the relationships or how you would use
the data, but in any case, this is preferrable to keeping it in two places.
One thing almost for sure is that at some point the two will get out of sync
and you will have incomplete or incorrect data.