Linking a field to another

[emucalfskin]

Sorry I am a novice and I am really hoping someone can help please! I have attached a screen shot 

We have a timesheet on our database, I need to create another field/script/no idea? My Manager wants it that when a specific task type is entered, another field comes up with keywords that relate to each different task type. For instance:

Someone adds Strategy as a task type, another field will open with the options Scope; Estimate; Wireframe

Then on the next line they choose Implement as a task type, the other field will then open with the options Technical build; Upload; Layout; Amends; Sign off 

I can't work out how the field will change dependant on the task type selected, the only way I can do it is that it will bring up all the keywords related to every task type, not the specific ones

And I probably haven't made much sense either? 

[Steve Martino]

I think what you are looking for is a conditional value list.  If so, there are many examples and sample files available by search.

[emucalfskin]

Thank you I will give it a try! 

[Lee Smith]

Try these two searches using google

site: fmforums.com conditional value list

site: fmforums.com dynamic value list