Database Reference
In-Depth Information
7. Repeat the above steps for the Line Items table. In this case, though, you want to
let managers edit or delete line items when the invoice they're attached to con-
tains today's date. So use the following in steps 3 and 6 :
Invoices::Date ≥ Get ( CurrentDate )
Project managers at your company have no business creating or editing payments or
products, so you can leave Edit, Create, and Delete set to “no” for Invoice Payments,
Payments, and Products. You'll add more granularity to these settings in the next sec-
tion, so leave the window open for now.
NOTE
FileMaker shows a “-” instead of the word “no” when you turn off a privilege. The dashes make the
denied privileges easier to spot when you're looking at a long list.
Field-Level Access
The Payments table has a field for Credit Card Number. This type of information falls into
the need-to-know category: Unless someone needs it to do his job, he has no business seeing
it. Even though project managers can view payment records, you can still control access to
individual fields in that table. You're about to exercise field-level granularity:
1. Select the Payments table and then, from the Field Access pop-up menu, choose
limited .
The Custom Field Privileges window appears ( Figure 18-6 ). FileMaker offers three
field-level privileges: Modifiable means people can see and edit the field data; view
only means they can see the information in the field, but can't change it; and no ac-
cess means they can't even see it.
Search WWH ::




Custom Search