Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

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

parasko
in Relationships

Featured Replies

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 by Guest

  • Author

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?

Create an account or sign in to comment

https://fmforums.com/topic/62429-how-do-i-avoid-data-entering-the-same-info-for-new-records/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.