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 October 31, 200718 yr by Guest

What you want is called a 'conditional value list' in FM.

http://www.fmforums.com/forum/showtopic.php?tid/190881/post/270393/hl/conditional+value/fromsearch/1/#270393

covers this topic and has a sample file courtesy of LaRetta

HTH

Phil