Hello, this is simple and though question, but I know You can help me:
I have an access DB and there are 3 tables. Master, John and Alisa.
In the Master table I write entries by hand:
ITEM DATE ASSIGN_TO
Banana 2018/04/13 John
Carrot 2018/04/15 Alisa
and so on...
So in another table - John - there is entry:
ITEM DATE ASSIGN_TO
Banana 2018/04/13 John
In Alisa table there is:
ITEM DATE ASSIGN_TO
Carrot 2018/04/15 Alisa
So I can assign entries to John and Alisa. John can see only items assigned to him and Alisa can see only items assigned to her. Both John and Alisa then can add more info to each entry, for example mark it as done.
It is some variation of assigning info to people. And we all 3 can access this table at the same time and manipulate data.
Is it possible and how to do that?
Bookmarks