Linked Data Bases for Mailing Labels

[Kennertoy]

Hello Ladies & Gentlemen. I have two data bases that I have created as a continuing learning project of Access. They both perform as I had planned (with help from your Forum). I have not had any formal trainging, so this question may make you chuckle. One data base is for an Address book containing just addresses of friends and family. The other is a Anniversary & Birthday book with Names, relationships for sending cards at the appropriate time of the year. The only downer is you manually have to go the Address book to get the information and write the address on the card envelope.

Now I thought - could I make address labels from using the data in both DB? Or, do I create a new DB and import data from the other two. I decided this to ask the forum this time before I get into trouble and have any issues I cannot resolve (not to say that I still could have some issues later).

Thank you for reading my post, and in advance for any advice.
I hope I have explained the problem well enough to all of you.

[RuralGuy]

Do both tables have a PrimaryKey (PK) field, hopefully an AutoNumber field? Will there *always* be a record in the AddressBook table for any record in the Birthday table and does the Birthday table have a ForeignKey (FK) field that contains the PK from the AddressBook table record?

[Kennertoy]

Thanks RuralGuy
Both have primary Key(PK) & both AutoNumber. There "Always is" a record in the address book for any record in the Birthday table. I put a new field in the Birhtday table called Foreign Key - Number. I don't know what you mean by having ' the Birthday table have a ForeignKey (FK) field that contains the PK from the AddressBook table record?' Do you want me to open the AddressBook table and patch the entries from the PK there to the Birthday table Foreign Key field?

Ken.

[RuralGuy]

Each record in the Birthday table needs the PK value of the Address table record so that the relationship can be established. You may have to do it by hand to get it started.

[RuralGuy]

Once each Birthday record has a pointer to the matching record on the Address table you can create the join. Then you can use a query to view the two tables as sort of one record. This make is very easy to display and use fields from either table any way you desire.

[Kennertoy]

Well RG you are the man!. I did find out however, that I did not have an address in the address table for every entry of the Birthday table. Anyway, I had already had the Qry made and after I manually updated the FK with the address table PK the qry ran like stink! (Pardon the phrase), but I was very pleased. I have made the labels and my wife is very pleased. Thanks for the lesson.

Ken.

[RuralGuy]

Glad we could help and thanks for posting back with your success!