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.

multilevel conditional lists

mathac
in Value Lists

Featured Replies

Hi,

I have: two tables, A the data file containing the records & B the options file.

On Table B

1. drop down list-Companies

2. 2nd drop down with the items.

The second list depends on the company chosen from first list. This works fine.

I need to then have the cost of the particular item chosen automatically appear in the field for "Cost".

Does anyone know how to describe how to do this?

M

I would have a Cost field in Table B lookup the Cost of the Item using a relationship to Items by ItemID.

Be sure to relate your records using IDs not text values. For example, you say that in "TableB" you have a drop down list of Companies. That doesn't sound very good, because it suggests that you are storing a company name rather than a companyID in TableB.

  • Author

Thanks so much. It sounds very simple. I will give it a try

M

Create an account or sign in to comment

https://fmforums.com/topic/74223-multilevel-conditional-lists/
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.