This is only help for part of your problem, but it may help get you started in the right direction. These are links about conditional value lists, where selecting a value in one field controls what values appear in the value list specified for a second field:
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.