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 List Problem?

DesignX
in Value Lists

Featured Replies

I have checked all over this website and i cannot see to find the answer to my question.

I use Version 6 and i have made a few databases with relationships and all.

i have:

Orders

Customers

UPS

Now what i want to do is in the UPS database is make a dropdown value list that populates based on another dropdown list. (confused???) read on:

in UPS Database i click on CustomerNAme and my Values are a lookedup value from the Customers Database. THis works fine but what i want to do is populate the P.O.Number Dropdown list with only the values that are associated with the CustomerName that i picked.

example:

in UPS Database i Click the CustomerName DropDown and Pick Company A. In the P.O.Number DropDown i want to display on the Values related to Company A not ALL the Companies. the CustomerName DropDown Values are Stored in the Customers DB and the P.O.Number Dropdown Values i need to come from the Customers DB.

Can anyone Help me.

  • 3 weeks later...
  • Author

I hate to bump this but i have upgrader to FM 8.5 Advanced and i am still having such a problem with the "subcategory" problem.

any help??

Create an account or sign in to comment

https://fmforums.com/topic/47985-relational-list-problem/
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.