Populating a list of tasks created by the user and assigned to various assignees

[kevin19]

A user, Paul creates a task and assigns to various assignees, say John,Jones and Smith.
When John logs on as a user, John opens a task form say, and wants to see a list of tasks he created himself and also a list of tasks assigned to him.
what is the best approach to create a form to achieve this?
I have created a main form called Task and a subform of the list of tasks.
I do not know how to link the user and the assignees in order to populate a list of tasks by the user and the assignees together.
Can someone please help as I am stuck and unable to move forward with my database. Thanks!

 

[StarGrabber]

I have difficulties to understand what you are looking for. First you say you want a list of tasks created by the user and also a list of tasks assigned to him, that is two lists, right? But later on you say you don't know how to populate a list of tasks by the user and the assignees together. Well, maybe you can find something useful in attached file.

 

[kevin19]

Thanks StarGrabber!
You certainly are a Shining star! Your file is indeed very useful as it does shed some light into whatever I am trying to achieve here.
Cheers matey!

 

[StarGrabber]

Glad to help. Good luck with your project!