views and rules
views and rules
От:
Nick Haw <nick.haw@operagrp.com>
Дата:
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)