Conditional Value Lists

[fieldsofpurple]

This is a common topic here, but I cannot figure my situation out. I have a table that lists "product line" and has up to 4 "category" fields.

Example:

Product Line: Category 1: Category2: Category 3: Category 4:

Floral: Bouquet: Dried: Small

Floral: Basket: Hanging

Café Cake: Regular: Carrot Tort: Slice

Café: Cake: Regular: Carrot Tort: Whole

Café: Coffee: Mocha: 8oz

Café: Coffee: Mocha: 12oz

Café: Cold Drink: Regular: Ice Tea: 12oz

So for each “coffee” drink that is a “mocha” there is an “8oz” record, “12oz” record and “16oz” record (3 records). I want to be able to choose only those fields that are related to those records.

Example:

Product Line: (chose from value list of: Floral, Café, Grocery, etc.)

Category 1: so if I chose “Floral” this list should only include bouquet, plant, basket, etc.)

Category 2: if I chose “bouquet” this list should include dried and fresh

Category 3: if I chose “fresh” this list should include small, large, self-cut

Category 4: (no further category for this choice)

At the moment, the product line field works, category 1 works, but category 2, 3 and 4 show all related values in those categories.

I have the field format’s all set to “pop-up list” pulling values from the defined value lists. Basically it all seems to be set up correct, but I’m still getting too many choices as I get further down into the categories and I only want to see those that are related.

Please ask if you need further information to answer this. I’m at a loss.

fieldsofpurple

[LaRetta]

Hi fieldsofpurple,

How are your value lists set up? Your Product Line can use 'values from field' and all values'

You need another TO called Product Line, joining the productID or field to itself. Then category1 value list would use THAT TO, as 'values from field' and in next popup, use values from field and 'only related values' to your new Product line TO. Repeat with category 2 (after creating a TO of category1, joining 'theField' to 'theField'.) Category 2 would use 'values from field' and 'only related values' and select category 1 ... etc.

LaRetta :wink2:

[fieldsofpurple]

LaRetta:

This is what my value lists look like:

Field: "PRODUCT LINE::product line"

Field: "PRODUCT LINE::category 1" (related values only)

Field: "PRODUCT LINE::category 2" (related values only)

Field: "PRODUCT LINE::category 3" (related values only)

Field: "PRODUCT LINE::category 4" (related values only)

So the "product line" field is set up to use all values

The "category 1" field is set up to use related values only from category 1

The "category 2" field is set up to use related values only from category 2

So on and so forth.

I feel I have it set up correctly as I went through your suggestion. Am I off by one field in my relations?

Thanks so far....fieldsofpurple

[LaRetta]

So the "product line" field is set up to use all values

The "category 1" field is set up to use related values only from [color:blue]product line

The "category 2" field is set up to use related values only from [color:blue]category 1

Each new conditional value list must look up the chain one level to get the related values.

:wink2:

[fieldsofpurple]

Thanks for working on this with me. There must be something else I'm not doing correctly as your suggestion isn't working. I have attached the table I am using to show an example of one of the product lines and the subcategories. As you will see in the table there is the "Floral" product line. When I choose that in my point of entry, I only want "basket, lavender buds, plant, potpourri, tussie mussie, wreath and bouquet" to pop-up in category 1. That part IS working correctly for all the product line to category 1. Then if i chose say "plant" ALL values in category 2 pop-up. Then if I chose say "1 gallon" ALL values in category 3 pop-up (obviously having nothing to do with the plant category).

Maybe I don't have something defined correctly in regards to my table or in the value lists.

thanks again for your advice.

fieldsofpurple

table.fp7.zip

[LaRetta]

You can't attach an fp7. You must zip or rar or stuff-it first.

[fieldsofpurple]

I'm so new at this. I've attached it as a PDF file. Hopefully you have adobe.

thanks LaRetta

table.pdf

[LaRetta]

Nope, doesn't work - just produces the field data. Do you have winzip or winrar or stuff-it expander?

You need to zip your fp7 file and attach THAT here.

... we're a patient sort. And everyone is new at everything at least once so not to worry - we'll work you through this yet.

UPDATE: If you find your fp7 file, right-click and find option about compressing!

LaRetta

Edited March 22, 2006 by Guest
Added Update

[fieldsofpurple]

I am not having any luck getting this file to send. My right click doesn't offer anything about compressing. The table I sent didn't have any records? I think I have to call it a day. But before I go, is there any information I can send you in this box that may help answer questions?

The only way I know how to send a file is to email it.

thanks...fieldsofpurple

[LaRetta]

I've messaged you here - look in your Profile (upper left) and then View Private Messages.

And if someone with a Mac can explain how you'all compress? I'm sure it will come in very handy for fieldsofpurple in the future. ^)

[Razumovsky]

And if someone with a Mac can explain how you'all compress?

ctrl click (rightclick) - 'create archive' will get you a zipped copy. Took me an embarrasingly long time to figure it out myself when I switched platforms.

-Raz

[fieldsofpurple]

Oh thank you for noticing that request so far into the topic! I sat here for a VERY long time myself completely perplexed! It doesn't seem to be common knowledge for us mac users!

[APost]

Can't speak to the Mac Issue, but I'm looking for the same solution. Pehaps I can rephrase the question.

I understand how to create a drop box for say TableA::FieldA, and how to assign it a value list that presents unique values that are currently in TableA::Field A.

But, I haven't figured out how to create a value list that will present TableA::FieldB with data choices that share a common value as the selection previously made in FieldA.

I bet this is the same issue fieldsofpurple is strugling with.

[LaRetta]

I thought I explained it pretty well.

But if you do a search for Conditional Value Lists here on FM Forums, you'll find many more posts on the subject; heck, I've even done a simple demo and I'm sure others have as well.

LaRetta

[BFrost]

Try This download. Rename the Fields to suit your own category names or just input category data in in this order of priority: Material Type, Material, Category_1, Category_1, Category_3.

IndexDemo.fp7.zip

[Gloria]

Using Value Lists in a calculation?

I'm very new to FM7, I've set up an inventory database & need some help with the Value Lists.

I have fields "Product ID" and "Product Description", these products are then sorted by Sales Catagory Value Lists "Grocery", "Pop", "Tobacco", etc., (which I have set up as Custom Value Lists. Problem, I've entered all the product onto an invoice with prices for each product, I now need to sort the invoice based on the value list Sales Catagory & come up with a total price for all "Grocery" entered, all "Pop" entered, "Tobacco" entered etc & I don't know if or how to enter the calculation based on the Value List. I hope I'm making sense, can anyone provide some guidence. Thanks

[AlanT]

You will have to excuse me, I am a beginner and I do not have a clue as to where to proceed with my conditional value lists. I am busy trying to get an inventory control DB up and running and I need multiple warehouses each with multiple locations attached. So if I select warehouse 1, I will get location 1,2,3, but if I select warehouse 2, I will get location A, B, C. I am still at a loss as to how to do this.