In this scenario, a User A can pre-create list of things and group them into categories as such:
- Item category 2) Item name 3) Item location 4) Creator (User A)
eg: My Cars/ Toyota/ Main Street : My Cars/ Ford/ North Oak … so forth
eg: My Bikes/HD / 8th Street : My Bikes/ … so forth
User A (owner of the list) wants to assign the list of My Cars to User B. Where User B can then edit the list and maybe change it for herself. So I need a copy of that list to be attached to a LIST field in User’s B table.
User B table or type has: 1) Receiver (User B) 2) The list (assigned by user A) 3) Modified yes,no
So basically I would be moving a sub-set of data from a list User A created to a table that will accessible by UserB in which one field is the sub-set list. And where User B can edit the list without affecting the original list created by User A.
Important: User A can assign that list a User C and that user can make changes for himself.
I hope I explained this clearly. Any ideas and overall strategies?