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.

Conditional Value List

j4jason83
in Value Lists

Featured Replies

I really hope I haven't missed something in my searches, but I have been unable to make this work.

I have 2 tables, components and computers. In my components table, I input all the info about each part of the computer.

Now I want to create a list for each part of the computer, (motherboard, processor, RAM, etc) that pulls data from the components table, but filters the results to the corresponding field.

I am not sure what I need to do to get this function to work.

Thanks in advance.

Jason

You're missing a table. Since a computer can have many components, and a component can be used on many computers, then you need to store the intersection. This is called a join table, and it resolves the many-to-many relationship.

Search the forum for "join table."

You'd put a portal on the Computer form to the join table, and populate the _kF_ComponentID.

  • Author

I thought I had that set up with this relationship.

Maybe I don't. Can you advise me on this.

relationship.JPG

Create an account or sign in to comment

https://fmforums.com/topic/64875-conditional-value-list/
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.