emucalfskin

Linking a field to another

4 posts in this topic

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? 

Screen Shot 2017-04-06 at 10.46.30.png

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Thank you I will give it a try! 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now