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.

Multi-to-One Relationships -- are they possible?

blakmac
in Relationships

Featured Replies

  • Newbies

Hi,

I'm running FileMaker Pro 6, and I'm totally new to the software. We are using it in a retail environment.

Currently, we have relationships defined, such as we enter something in the "Part #" field, and it puts data from that file into the "Description" field.

My question is, would it be possible to define relationships in a multi-to-one format where I could type in the "Year", "Model/Size", and "Description" and have it fill in the "Part #" field from the inventory file without having to create another file for this process?

I'm sorry if it's a silly question, I've been using this program for about 4 weeks.

blakmac

Of course you can do this. This is essentially a lookup-type relationship.

On each side you'll need a calculated field which is a combination of Year, Model/Size and Description. Use those to setup a relationship and then the Part# would be defined as a lookup via that realtionship.

But if you already have a lookup for Description, with the part# as key field, you might run into a 'circular definition' problem.

  • Author
  • Newbies

what's that?

Field A requires Field B which requires Field A

or

Field A requires Field A (typically because of a relationship)

Create an account or sign in to comment

https://fmforums.com/topic/17203-multi-to-one-relationships-are-they-possible/
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.