|
Here are some demonstration files that illustrate various
FileMaker concepts. These files are provided on an "as is" basis (use at your own risk). Feel free
to pull them apart and see how they work.
Invalid
Relationships - courtesy of Debi Fuchs
This demo file dramatically illustrates
the performance advantage of using an intentionally
invalid relationship to pass global data between
files.
|
FMP:
5/6
.zip
|
|
Portal Sorting
Three demos, showing increasingly-sophisticated approaches. (The first two demos will work with FileMaker 5.0 or newer, the third uses the GetField function, so requires FileMaker 5.5 or newer.)
|
FMP:
5.5/6
.zip
|
Pick List with Cost of Materials
If you have inventory items built from sub-assemblies (which in turn may contain sub-sub-assemblies, etc.), you'll want to check out this demo. Specify the quantity, and you'll get a complete pick list with cost of materials.
Based on Rich Coulombre's "Hamburger Shop" example (used with permission). |
FMP:
6
.zip
|
De-dupe
Comparison
Six ways to
de-dupe a FileMaker file.
|
FMP:
5/6
.zip
|
Multiline-Key
GTRR
While you can do a GTRR ("Go To Related Record")
on a single record, and view related entries that are one relationship
step away, versions of FileMaker Pro prior to FM8 do not offer an obvious way to do either
of the following: a) View related entries that are more than one
relationship step away (e.g., for a given customer, locate all
items they have purchased), or b) Start from a found set rather
than a single record (e.g., in a found set of all September 2000
invoices, go to the found set of all related customers). Using
multiline-key GTRRs, you can easily do both of the preceding.
|
FMP:
5/6
.zip
.sit
|
Dwindling
Value Lists - Brute Force Method
Sometimes when you pick an item from a list, you'd like that
item to vanish from the list to avoid the possibility of double
entry. For example, if you are creating a work schedule, once
you've scheduled an employee, it would be nice if that employee's
name would be removed from the list of potentially-schedulable
employees -- for the current day's schedule only, of course. |
FMP:
5/6
.zip
.sit |
Dwindling
Value Lists - TroiText method
A more elegant implementation. Requires the TroiText plug-in. |
FMP:
5/6
.zip |
Grade
Ranges
Check off all the grades (from K through 12) a teacher has taught,
and have them display as a range. For example, if a teacher has
taught grades K, 1, 2, 3 and also 6, display as "K-3,6". |
FMP:
5/6
.zip
.sit |
Counting
Values
Say you have a checkbox-formatted field showing all the letters
of the alphabet. And say that for each record in your database,
one or more checkbox values are chosen. You'd like to be able
to report on how many of each are checked, for the entire database,
or just for a subset of your records. If that's your situation,
this demo is for you! |
FMP:
5/6
.zip
.sit |
Incidents
This demo takes a collection of police "incident" data
and summarizes it by four different criteria on a single page
report. The Status(CurrentScriptName) function gets a real workout
here. It's also a good illustration of how a report can simply
be a collection of global fields on a form view layout. |
FMP:
3/4
.zip
.sit |
|
