I am not very well versed in storage (databases), but how does SharePoint save tasks for multiple people? I understand excel and some Matlab. (note: vertical bars denote row changes)
For example, if a site has two people with individual tasks, I imagine a 2x2 table with a task column and a user column. Like so,
- User A | Task A
- User B | Task B
If another individual is added to the task, does the table stay 2x2 or does it add another row to the table, duplicating the task, so making a 2x3 table? Like so?
- User A | Task A
- User C | Task A
- User B | Task B
Or conversely, does it still store the values in a 2x2 table, with multiple items per cell?
- User A, User C | Task A
- User B | Task B
Thank you for all of the help. I am trying to picture this structure in order to eventually add and delete people from tasks (sometimes assigning the same task to more than 50 people, each one requiring action) using custom workflows and InfoPath. Thank you all very much again.