Updating and sql

[Xzibit7]

Does a form based on a complicated sql statement not allow updates to the data it shows?


such as SQL statement

SELECT S.* FROM (supervisor AS S INNER JOIN Userinfo AS U ON S.assignedto=U.username) INNER JOIN Userinfo AS C ON U.GroupId=C.GroupId WHERE C.username = CurrentUser();

 

[Xzibit7]

Okay I seriously need to stop asking questions....There is a new table created with this so I have to just use this as a list that I can select from, basically it is not updateable

 

[PHV]

Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886