many to many & limit user access

[Blue Dolphin]

Could you please help with relationship and restricting user access to only their pertaining task and role records

I started developing the relationships but not sure if it is correct and not sure how to limit user access. Please see attach file and scenario below. thanks a million.

A person can have many roles.

A role can be given to many persons.

A person can have many task.

A task can be performed by many persons.

If a user enters the db with account name John and password Doe then he can only view and create tasks pertaining to himself only.

If a user enters the db with account name Maria and password Gonzalez then she can only view and create tasks pertaining to herself only.

Thanks a million for correcting my errors and trying to help.

Task_DB.zip

[bcooney]

See this thread Link