You are dealing with two concepts here, conditional value lists where you choose a value in one field such as your category field and the list of values displayed in another field updates to only list values that are a member of that category, and table occurrences--which is how you can set up more than one relationship between the same pair of tables--one for your portal and one for you conditional value list.
To learn more about conditional value lists:
Forum Tutorial: Custom Value List? (Use option 2 for your situation.)
Knowledgebase article: http://help.filemaker.com/app/answers/detail/a_id/5833/kw/conditional%20value%20list
To learn more about table occurrences and how to use them:
Don't hesitate to post back here with any questions you have after reading all of that.
Thanks for the links, your demo file was unknown to me and the most helpful.
Using the Filemaker Tutorial as mentioned above I have introduced category in the product table, and I can now select a category and select a product in the line item, and display it's price using a lookup.
Next step ? Introduce a sub category, And again.., I'm locked ...
Others tutorials or demo files to help me understand once for all ?
Thanks for your care.
So you select a category to get a list of sub categories for that category, then select a subcategory to get a list of only the products in that subcategory?
Subcategories require additional occurrences of product linked by the sub category field instead of category.
Here's a demo file where another poster and I worked out an entire chain of such conditional value lists. http://www.4shared.com/file/gd6_fDgn/conditional_value_listDec.html
Exactly what I was looking for !
The Order Line Items works fine for existing products.
Howewer in Layout mode some "tables are missing", which doesn't help me for mastering this other forward step which is introducing new catetories/sub-cat/sub-sub cat/products.
Would you have a version more explicit for this ?
Only in one layout that I can see. This file was created and shared by the other user during our collaboration on the issue and I didn't spot that. I've updated the file to fix the broken reference on that utility file. Please click the download link again and download the udpated copy.
Thanks for caring.
Layout "product sub categories", and layout "product sub sub categories" : <Table Missing>.
Fixed. Updated copy can be downloaded from same download link.