Jump to content

Combo box based on another combo box


ChiknNutz

This topic is 6076 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hi, I'm an Access user, trying to convert over to FM. I'm assuming this is an easy one, probably already covered, but wasn't sure. So, I have two value lists (combo boxes). I want to base one list on the other...showing the related items. In Access, this is done thru a "Lookup" command. The data all exists in one table, but I want to filter the results so as to not show every record, so a filtered list is the best as I can describe.

Example:

Table: Brand X, Product 1 (and on)

Brand Y, Product 1 (and on)

Brand Z, Product 1 (and on)

Form/Layout

List 1: Brand X, Brand Y, Brand Z

List 2: Product 1, Product 2, Product 3

So essentially what I want is, the user selects Brand X from List 1 FIRST, then selects the desired Product from (the now filtered) List 2.

Am I making sense? If so, how is this accomplished in FM? Thanks much.

Edited by Guest
Link to comment
Share on other sites

This topic is 6076 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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