Conditional value list trouble

[kirvis]

Hi all,

I have a database system where I can assign categories to a product. There are three levels: category, sub-cat, and sub-sub-cat. I have managed, with a little help, to create conditional value lists for the categories. The sub-category you can select depends on the category you have selected etc.

Now I want to be able to compile orders, so I have created two extra tables: orders and order_line_items. From the order layout, I would like to have a portal for the creation of this order. I then want to be able to select the category and sub categories and then finally, based on the sub-sub-category, the product.

The first problem is that my conditional value lists for the (sub(sub))category do not work in the portal. They do however work when I add a new product record. I do not see what I am doing wrong here.

The second (and most important) thing is that I want to create a conditional value list for products, based on the (sub(sub))category. Because eventually the products table will have a lot of entries, I need the conditionality of the products value list to make working with the system easier and faster.

I know that it must be possible to create this value list, I just don't know how. I have had a great deal of trouble with conditional value lists before, and I hope that someone here will be able to help me out.

I have included the file I am working on.

conditional_value_list.fp7.zip

[kirvis]

The first problem I have handled now, by creating a ton of new TO's and creating three new value lists, starting from the order_line_items table.

I however still do not know how to create the conditional value list for the "products" table, based on the (sub(sub))categories that are selected. Does anyone here have a clue about this?

See attachment for the updated file.

conditional_value_list.fp7.zip

[MetaSys Software]

Hi,

Please refer 'New Order' layout in attached file. Created separate Table occurrences, new value lists and a layout based on them. value list for sub category, sub sub category and products is based on table ocurrences related to order line item table.

conditional_product_value_list.zip

[steveald]

I attempted to use [color:blue]MetaSys Software's revision to [color:blue]kirvis' conditional value list database to learn how to set up something similar in a database I'm working on.

My experience with multiple tables within one database is limited. As a result, I don't understand how this works. My needs are more basic than the example here, so hopefully a simple tutorial will be enough to get me started.

Each record in my database will have one of three Departments to pick from and, within each Department, one of several Divisions. All I need is for my User to create a new record, select the Department, and then have a specific list of Divisions to select from based on which Department was selected. That's it!

Can someone help?

[mr_vodka]

Try this example instead.

http://fmforums.com/forum/showpost.php?post/269504/

[steveald]

That looks much closer, thanks. But it brings up two questions.

- Can it be modified so that, once my Department is selected (like the City in your example), a list of Divisions is made available that is unique to that Department? The example appears to offer only one State for each City and one Zip for each City/State. I need to do the opposite - select a "State" and then select a "City" from a list that is unique to the "State" I selected.

- Perhaps even more basic; how do you create those "Tables" in the Relationships tab that don't exist as Tables themselves but appear to be subsets of existing Tables? (Zip Codes_City is one in the example database.)

Edited January 28, 2010 by Guest