There's no pratical upper limit to the number of conditional value lists as far as I can tell. Each conditional value list requires its own relationship--so as long as you can keep adding relationships, you can keep adding more conditional value lists. The conditional value lists can be "linked" where the choice in each value list updates the options available in the next or they can be separate from one another.
Thank you for your reply.
I have found a post you have done in december last and i think its what im looking for.
ParentTable::ExpenseCat = ValueTable::ExpenseCat
ParentTable::ProductType = ValueTable 2::ProductType // make ValueTable 2 a table occurrence of ValueTable
If you define ValueTable with three Fields: ExpenseCat, ProductType, Item
You can define 3 value lists:
Expense Categories : specify values from ValueTable::ExpenseCat
Product Type : specify values from ValueTable::ProductType, show only related values starting from ParentTable
Items : specify values from ValueTable 2::Item, show only related values starting from ParentTable
I have currently got: View::DASH=DATA ENTRY::dash now i understand this is for 3 conditional lists at the moment i can only get one option after the selection. How do i go about settingup 11? if you dont mind me asking?
Keep in mind my suggestion on your original post that maybe conditional value lists may not be the best approach here.
Adding more linked conditional value lists is just extending the process to more fields and/or more tables of values all filtered by the values used in the relationships.
The post you are referring two sets up TWO conditional value lists and one value list that is not conditional. It sounds like you are having trouble setting this up for two conditional value lists. If you can get that working for you, I think you can then extrapolate the process to add more cascading value lists here.
The post you quote shows two relationships for these two conditional value lists, but you describe using only one relationship for this?
You'll need to describe what you have set up and how the data for your 11 value lists are structured before we can do much more here. (You could have replied back to your original post to bump it back up to the top and then we could more easily see that original screen shot. You can still edit your first post in this thread to add that screen shot here.)
My boss is quite insistent that conditional value lists is the best user friendly option for what we want at this time.
I have created a new test file to try to work this out a different way if i can.I will post a piture of my relationshiop structure also.
I have created conditional value list many times and they work quite well however there are only ever 2 levels no more so i am having gret difficulty in getting my head around the realtionships for this 11, if u can give any advice in where i am going wrong i am open to all suggestionas and advice.
Can't see any new image posted so I'm still waiting to see more. Here's a demo file where I and another poster worked out a series of value lists based on more than just two conditional value lists: http://www.4shared.com/file/gd6_fDgn/conditional_value_listDec.html
You may be able to glean a few clues from it.
The biggest pitfall developers run into when setting up a series of cascading conditional value lists is that all the conditional value list table occurrences have to be directly related back to a common table occurrence--usually the layout's table occurrence--and not in a "chain" of relationships to each other.
Thank you for the link i will try and see if i can figure this out using it. I dont exactly know how to upload a picture but il head on with this and see if i get anywhere,the post i referred to yesterday is what im looking for with regards catagories.The way its filtered, Maybe like you said conditional value lists might not be the best option can you suggest anything else?
i have looked at the link and im afraid im just bk to square one.
I have been trying to use a calculation instead but still no joy. All im looking to do is make a multi level conditional value list but im afraid im lost and i think i must be overlooking the solution or just not looking at it enough
any help more than appreciated
I wouldn't use a calculation field for this. That's a very limited option that works well only in certain applications and a "chain" of 11 conditional value lists isn't one of them.
The easiest place to upload an image is to go back to your original message at the top of the screen and click Edit Post. You'll then have access to a place where you can upload a screen shot from your computer to the forum. To add am image to another post other than the first, you have to upload the image to a file sharing site and then post a link to that image file here.
The demo file has multiple cascading conditional value list where each selection narrows the list of options listed in the next value list. That should give you a good example of how to set this up.