how do I avoid data entering the same info for new records?

[parasko]

Hi all,

I have created a database for books. There is a 'Publisher' field which is a drop down list. For each Publisher, there is a Distributor and Address details.

How do I avoid data repeatedly entering the Distributor details for each new record when I select the relevant publisher?

eg. If I choose Oxford University Press, I want the name of their distributor and address details to automatically appear in the relevant fields.

How do I achieve this?

Do I have to create a child 'Distributor'database to link to the primary and then link the Publisher field to the Distributor fields in some way?

Secondly, could I add new Distributor details directly from the primary or would I have to go the 'Distributor' database each time new distributor details arise?

I'm really new to databases (and others using the database know less than I do) so any advice in plain English would be much appreciated.

Thanks in advance.

Edited September 23, 2008 by Guest

[parasko]

As an addition to my original question...

...can I somehow use the 'Publisher'field as a global field so I don't have to create a child database with details of Distributors?