Jump to content

Auto population of a field based on 2 other dynamic value lists

Recommended Posts


Hi All,

I am building a personal diary.

It has 2 tables, Tasktimer (which category, task and times the activity) and Categories (which is a 3 field list of Categories, Tasks and Remarks).

I set up a relationship for the 2 tables via a Category field in both tables. This then allowed me to set up dynamic value lists, which I want to filter choices based on what is set in the Tasktimer table.

In the Tasktimer table now when choosing a Category, it shows me the list of categories from the Categories table. After choosing a category from the list, the task list is filtered based on the category. I would like the remarks field to auto populate with the filtered and one remaining item from the list of remarks in the Category table.

I'm struggling to do this, I can only ever get the remarks to filter based on the Category field and not the Task field. If i can do this, then there will only every be one outcome for the remarks field.

Jesus I hope this makes sense :S

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use