January 17, 200223 yr Newbies 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.
January 17, 200223 yr 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.
January 22, 200223 yr 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.
Create an account or sign in to comment