i have worked with access and understand it
Sometimes that can add to the challenges of getting FileMaker to work. A SQL based approach often is not possible in FileMaker, so you mentally reach for that familiar tool only to discover that you have to use a very different approach to get the same results in FileMaker.
What you describe, we call a "Conditional Value List". Here are some links to help you get up to speed in how to set these up in a FileMaker Database system:
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.
OK thanks I think i have that one down.
What i'm really trying to do is get multiple value list from one table..
Knee/hip list etc based on one table and layout which inputs the information
Here is the table i have..I have pull down menus set up to enter lifts
Lift one is all ways explosive, lift 2 is all way Knee/hip and so on.
Now my finished table will have hundreds of different lifts as they are added or taken out.
How would i go about making a value list for each classification ( there are 15 different ones) I don't want 15 different tables
thanks for the previous help
It depends on how you specify the lift category.
With a conditional value list, you can select "explosive, Knee/Hip, Horizontal Push..." from one field and then the conditional value list in the next field lists just the values that are a member of that category. You can define as many categories for your lifts as you want all in this one table.
If you are defiing multiple fields for this in one record--not something I would do in Access or FileMaker, I suggest setting up a portal to a related table to make the resulting data something that is much easier to work with.