Jump to content

Conditional Value Lists


fieldsofpurple
 Share

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

Recommended Posts

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

Link to comment
Share on other sites

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:

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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:

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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. :wink2:

... 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 by Guest
Added Update
Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

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. }:(^)

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

I thought I explained it pretty well. :blush2:

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. :wink2:

LaRetta

Link to comment
Share on other sites

  • 3 weeks later...

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

Link to comment
Share on other sites

  • 4 weeks later...
  • Newbies

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.

Link to comment
Share on other sites

This topic is 5682 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
 Share

×
×
  • Create New...

Important Information

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