Apologies for the size of this "info dump" but there's a lot out there on conditional value lists.
There's a lot of overlap between the first two links so you can read one and skim the other. The demo file gives you several examples of different conditional value lists so you can examine them to see how they are set up. If you are using FileMaker 12 or later, you can open this demo file from your File menu to get a converted copy of the demo file that you can examine in your version of FileMaker.
The last link discusses how to set up a chain of conditional value lists where the value selected in each conditional value list controls the values listed in the next value list.
Forum Tutorial: Custom Value List?
Knowledgebase article: http://help.filemaker.com/app/answers/detail/a_id/5833/kw/conditional%20value%20list
Hierarchical Conditional Value lists: Conditional Value List Question
Feel free to post follow up questions here if those links aren't enough to get your value lists working correctly.
Thank you PhilModJunk, will review your links tonight and hope that does it. Will let you no either way
Ok guys I have not had much problems working though filemaker building my database but wow after a week of following the links above and studding relationships one would think I would have figured this out but I'm not. I'm asking for some help on how this should be put together here.
I have multiple tables one for each category as follows, Project, Manufacture, Product, Type and Color . With the relationship set correctly I should be able to select the Item that matches based on my selection from the last table. This is how I set the relationship:
Linked each table together with ID (number) link to ParentID (number) See attached Photo. With the Last table set with a second occurrence which is set back to the Project which should bring me all the subcategories that match that Project.
"Project Type= Project ID" and "Project Type = Parent ID"
"Manufacture= Manufacture ID" and "Manufacture = Parent ID"
" Manufacture Brand= Manufacture Brand ID" and " Manufacture Brand = Parent ID"
" Manufacture Brand Type= Manufacture Brand Type ID" and " Manufacture Brand Type = Parent ID" "sort by Project Color :: Manufacture Product Color"
What is it that I may be missing here?
On a layout based on what table are you setting up this value list?
Sorry, but It doesn't answer the question.
You are trying to get a conditional value list to work on a layout. Please open Layout Set and report the name shown in "Show Records From" in this dialog. Relationships evaluate from a "context", a particular record in a particular table via a specific table occurrence. The table occurrence is the name you'll find in this drop down list.
That value list will be empty if there is no related record in MFG Brand Type. If there is such a record, you should see a list of all colors that have a record with the same Project as the project of the related Brand Type record. You can double check the relationships used in a conditional value list by putting a portal to the value list's table occurrence on the layout of your "starting from" table occurrence. In this case, that would be a portal to MFG Color sort by project placed on your Mfg Color layout. The values shown in the portal should match the values in your conditional value list.
Got it now Thank you... Took a break and fit it this morning was done with that in 5 min... Some times its good to clear ones head lol