Inserting records into Multiple Tables at one with DataAssist is this possible
I have the USER id in every other table using Foreign keys.
I will as you say insert the userID in the session variable for each form/page.
I will try the insert server behaviour tonight.
In addition if there are other foreign key columns I want to record do I insert these as a hidden field?
I am not sure hopw to do this: "add in a where clause and say to make it select the records where the userID is equal to the session variable for the logged in user."
I also want to search where the userID is equal to the session variable for the logged in user.I think this is all generally part of the same question.