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.

Can you narrow down records in a portal using conditional value lists

Featured Replies

I have a database I developed a ways back with tables ORDERS, LINEITEM, PRODUCT, and PRODUCTGROUP. Each Product belongs to a Product Group. Groups are essentially master products and the products are style variants of the master product or product group they belong to. So for example, master product Chair and product is Chair Red (style), Oak (material). The reason for breaking the products down this way is because of a draw on an inventory parts list that is different for each product variant.

Till now everything has worked beautifully. I create LINEITEM records via a portal on the order page and currently have it working via a relationship between _kProduct(Product) and _fkProduct(Lineitem). I select the products from a dropdown list populated by product names. But recently, the list of Products has gotten so long that the drop-down Product Value list is getting too long. So, I'd like to narrow down the list for the users starting with ProductGroup (only 12 compared to the 60+ list of Products). Ideally, I'd like the user to be able to make selections in the portal starting with Product Group and then moving through Style and Material (populated by conditional value lists sorted by Product or Product Group).

My question is: is it possible to set up a portal where the user is able to select products based on criteria like product group, style and material rather than having to select the end product itself? Can filemaker find the appropriate end product?

Create an account or sign in to comment

Important Information

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

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.