automatic entry from other db

[Pavla]

To describe the problem:

In database 1 I have two entries: Newspaper name and circulation of the Newspaper

In database 2 I have the field Newspaper, where I have a list field with the relationship to the db1, and a filed circulation.

I need the following: when I take the Newspaper XXX from the list field, in the field circulation should be then automaticly the circulation from db1 belonging to newspaper XXX.

How can I do this?

Thanks for help!

P.

[Kurt Knippel]

A lookup via the relationship to DB1 by Newspaper name. Lookup is one of the field options. Check the help files for specifics on how to setup the lookup.

[falkaholic]

Make a relation to from Newspaper name to newspaper name in db 2. Then place related fields in DB2.

That way is better then lookups because they will instantly update any change in circulation. If you don't want that; use lookups.