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.

Relational value lists on the web (cdml)

Featured Replies

  • Newbies

Greatings

Sorry if this has been talked about earlier.

Case: I have a produkt database with aprox 1000 products. In the database I have three dynamic value lists (from three fields in the database):

cat1 = main category

cat2 = sub cat 1

cat3 = sub cat 2

There are 8 main categories. In the 8 categories there can be several sub categories, and under these sub categories there can be several categories. The products can not be listed until all three categories has been run through.

Now, I want to click on a main category and have a list of all the sub categories corresponding to the main category I clicked on. Then I want to click on a sub category showing sub 3 categories corresponing to the sub category I clicked on, and finally when clicking on cat 3 showing the products in this category. My mind is confused already...

I have no clue how to fix this - not in the database, nor on the web with cdml. Anoyone?

Regards,

Kyrre, Oslo, Norway

There are a couple ways I can think of to do this: the first of course is the "static" way, which is to do multiple pages with get forms that basically show the results from the previous form post and the results on the next page. The down side of this is that you are getting/posting multiple times and there is a couple-second pause when it happens.

The other way to do this is with javascript calls that do the same thing, making it look far more dynamic. I've seen this done, and can point to a consultant who can do it for you pretty cheaply. Email off-list if interested.

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.