Thread: views and rules

views and rules

From
Nick Haw
Date:
I have created the view below, I want people to only be able to update 2
fields (fldpaid and fldpaiddate) in the view. How do I go about doing this?

Many thanks

Nick Haw

CREATE VIEW "vw_invoicerestricted" AS SELECT
tblinvoice.fldinvoicenumber,
tblinvoice.fldinvoicedate,
tblinvoice.fldinvoicecompany,
tblinvoice.fldinvoiceclient,
tblinvoice.fldsurveynumber,
tblinvoice.fldtheirref,
tblinvoice.flddescription,
tblinvoice.fldchargevat,
tblinvoice.fldcompany,
tblinvoice.flddivision,
tblinvoice.fldpaid,
tblinvoice.fldpaiddate,
tblinvoice.fldcreditnote,
tblinvoice.fldinternalinvoice,
tblinvoice.fldoldinvoicecompany,
tblinvoice.fldoldinvoiceclient,
tblinvoice.flddateadded,
tblinvoice.flduseradded,
tblinvoice.flddatemodified,
tblinvoice.fldusermodified
FROM tblinvoice WHERE (tblinvoice.fldcreditnote = 0)