>Thanks...
>
>I got my view created fine. I cannot edit it in the view designer because it says my query is too complex.
>
>I need to know how to make it updatable. Here is my command to create the view. Can anyone tell me what I am missing to make it updatable?
>
>CREATE SQL VIEW testview AS SELECT fnpriority, fcworkordr, fcgrade, fccolor, fcthick, SUM(fnweight) AS fntotweigh, COUNT(fnstockno) AS fncount, SUM(fntimtorun) AS fntimtorun, fmpriormks, fnstockno, fnslitline FROM pplus!MASTCOIL WHERE !EMPTY(fcprocno) GROUP BY fcworkordr UNION SELECT fnpriority, fcworkordr, fcgrade, fccolor, fcthick, SUM(fnweight) AS fntotweigh, COUNT(fnstockno) AS fncount, SUM(fntimtorun) AS fntimtorun, fmpriormks, fnstockno, fnslitline FROM pplus!SLITCOIL WHERE flcut GROUP BY fcworkordr
>
>Thanks for any assistance.
>
>Tommy
I don't think you can make a view with a GROUP BY clause updatable. If you take a simple case where there were 3 records in a table and you used the SUM command, which of the three would you update?
Chris McCandless
Red Sky Software