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.