Newbie relational database question

[johnthompson]

I have been using a database to record address and contact information for publications in the UK. To make data entry easier, I decided to separate the information out into separate relational databases. I now have four databases - a master database into which I want all data entry and modification to be made, a publications database, a publisher database and an address database. Each contains the following fields:

Master - Publication title, Publisher, Address 1, Address 2, Address 3, Address 4, City, County, Post code, Telephone, Fax, Web site (plus other unique fields)

Publications database - Publication title, Publisher, Address 1, Address 2, Address 3, Address 4, City, County, Post code, Telephone, Fax, Web site

Publisher database - Publisher

I want to be able to enter, modify and delete all data in the master database, simultaneously updating the other three databases. How would I do this?

[kennedy]

Why would you do this?

The Master DB can already be used for anything that the Publications or Publishers databases would be used for... as you have them.

Either go with just the Master DB, or go with the other two and get rid of the Master DB.