Value LIsts from 2 separate fields

[DanielSie]

I'm new to filemaker, so please bear with my "technical" terms. It looke like I'd have to build a relational database. Oh, what a headache.

I have a table of clothing styles. I have a table of trims. A style uses more than 1 trims. A trim has more 3 dimensions.

Is it possible to create a drop-down that lists values from dimension1 field and dimension2 field?

Here a URL to my layouts:

[Reed]

you can show values from two separate fields in the value list setup, but one of them is usually going to be a key value that you don't want to display. To display more values, you'll need to create a calculation field that concatenates all your values. Then use that new field to display what you want.

CalcField=TrimName&" "&dimension1&" "&dimension2

[DanielSie]

Thanks for your reply. But it's not what I was looking for. Sorry I was not clear with my question.

A style uses a trim. Each trim has 4 different dimensions. What I was looking for is: after I created/modified a record in the styles table with a specific trim_id, I would like to have a drop-down list that shows only the dimensions for that trim.

So there is a trim table with trim_ids and each trim_id has 4 dimensions that I created 4 separate fields for. Then there is the style table. Each style uses 4 trim_ids. Each style uses a trim, but only 1 dimension of that particular trim.

For example when I'm in the style table modifying a record, I select a trim_id for trim_id1 field. Then for the trim_id1_dimension field, I would like to have a drop down list of dimensions for that trim_id1 only.

I'm sorry I'm rambling here, i don't know how else to explain it. Thanks again.

[Genx]

What i think you're looking for is conditional value lists, I haven't actually looked at this file but JMO did it so i'm pretty sure it will be quite useful (assuming that it is in fact what your after) http://fmforums.com/forum/showtopic.php?tid/177620/post/209609/hl/%22conditional+value+list%22/#209609

[DanielSie]

I found my solution by using a combo of List(), Conditional Value List and Trims table occurence.

To prevent more than 1 relational path between 2 tables (which I heard is a no-no)

I created occurences of Trim table: Trim1, Trim2, Trim3. Then I created relationships from the Style table of fields Style's trim1_name to Trim1's trim_name. This also helps me to create portals so that the trim suppliers' names shows in Style's trim1_vendor field.

My next goal to create a value list so that when a specific trim_id is selected in Style's trim1 field, only dimensions of trim1 will show in the drop-down list for trim1_dimension_used field.

So I created a new field in Trims table that lists entries of trim_dimension1, trim_dimension2, trim_dimension3.

Then I created value lists Trim1_dimension_all, Trim2_dimension_all, Trim3_dimension_all. Listing values from table occurences of Trim1, Trim2, Trim3 and set them to include only related values from Style.