By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,034 Members | 1,714 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,034 IT Pros & Developers. It's quick & easy.

Create Table Relationship

P: 83
Hello. I have two tables and some of the fields are the same. I have one primary key for both, and that is case number. One table is what is called Master_Log...this is the main log. I have another table that is a mailmerge table. This was already created before I designed the access database. I have imported the mailmerge database into the main database and created a relationship between fields that were common in both. The tables are not the same in every way.
When I create a case for the Master Log, I would like to create a case in the mailmerge table with information, namely the variables that are the same in both.

OR
I could always add the variables that are not the same to the Master Log, and have one database. This seems easier. However, some of the variables are different names. I just don't want to have to change all the names in the word document. Is there a way to change the name of a variable in a mailmerge.
Sorry this is a long drawn out question. Thanks
Apr 14 '07 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,419
You could have 'coupled' tables.
Mostly used when part of the data must match another system or similar, but extra data is required which would otherwise be stored in the same place. They would need to be joined with a one-to-one relationship on the Primary Key.
Apr 23 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.