inserting, updating, and deleting records and associating them to the user id
I really appreciate your help doing this.
I hope I am on the right track too.
I have attempted to follow your instructions:
"As for the where clause you will need to update the recordsets to ensure that they only let you update or delete entries that match for that currently logged in user. To modify these recordsets you will need to edit them from the server behaviors. In the simple view you would need to update the filter section and filter based on the userID column equal to 'session value' then enter the name of your session variable that holds the userID.
If the recordset it too complex then you may need to make this update manually in the sql that is on the page."
In deed the recordset is too complex. But I have absolutely no idea how I "make this update manually in the sql that is on the page".
Can you describe how I do this indepth perhaps with an example please?