duplicate and exact db and structure

[Mike1961]

I made a DB with the fields I need, the lookup I need (Thx kevin) and browsing/editing parameters that are OK to me.
This db is called tasks and I have a selection of people that needs to fill the db
But, it will be easier to filter the db by people. So, each person will create/edit his tasks only.

is it possible to duplicate the entire db and the way data are displayed to obtain several forms almost identical except that it will be filtered directly for the person ?

Directly into phpmyadmin ?

[kev1n]

Does this help? How to restrict users to view only their own records

[Mike1961]

Not exactly.
It's a collaborative set of tasks, so everybody should see anybody else tasks, but a user should create or edit his own task, not other's tasks.
In my case, liberally translated, user Luc can see tasks made by himself and Sergio, but when creating (or editing) a task, the field (assignee) should be Luc and nothing else should be allowed.

[kev1n]

Isn't that exactly what is described in the linked article under "Using the nuLog column"?

[Mike1961]

Isn't that exactly what is described in the linked article under "Using the nuLog column"?

Yes for editing (creating is also under the same rule ?). But is this a subrule of viewing only his own tasks or is it separate (the code will prevent user to create/edit tasks for others but still be able to view them all) ?

Thank you

[kev1n]

"Using the nuLog column" is a separate code and actually it shouldn't be in that article.