Thank you SO much for responding! I am desperately trying to solve this part of my app so I can move forward with my project.
Regarding your solution. I am looking for a solution that provides a more automatic result for the user. My app provides users with a searchable database (Table_A) where users search the database and are presented with results. Each user can save as many individual results as they want into another table (Table_B).
Table_B is full of copies of results from Table_A, differentiated by user_ID. So theoretically, you and I can both save item #5 to Table_B and when either of us search Table_B, we only see the one copy of the item based on System Authentication.
I have another table (Table_C) which is a table full of comments that are tied to each of the individual results from Table_B. But I don't want to get off track on that part right now.
What I am trying to achieve is this: I want users to conduct the initial search in Table_A (which is non-editable by anyone but Admin) and when results are presented, I want there to be some identification (automatically on load) in each line of the results, for each item; if that unique user has a copy of that item saved already to Table_B. Something like "Saved by: User_#5"
And for each item that is NOT already saved into Table_B for that unique user, in the place of the "Saved by: User_#5" option; I want there to be a button that says "Save Item". This button then makes a copy of that single item from Table_A, to Table_B. When it makes this copy it copies over the User_ID to that copy, so that record in Table_B is then unique to that user...even if there are already 500 other copies of that same record by 500 other users.
I hope that makes sense? =) The most important part is, both the "Save" button and the "Saved by" printout, are unique to each user. So at any time, each user can see either option for the same record.
Thanks again for ANY help you can provide!