Hi All,
I'm quite rusty with Filemaker and having trouble with the following:
I have 2 database files.
1. ENTRANTS
2. CODES
Entrants has about 1,000 records. The records have a field named CLASS. CLASS is a related field that pulls up information in the CODES Database. I want to display a count of all Classes in a different database file. The new file will be called TASTE.
e.g.
record 1 - CLASS 120
record 2 - CLASS 100
record 3 - CLASS 120
record 4 - CLASS 100
record 5 - CLASS 150
sub summary results yield
CLASS 100 - 2
CLASS 120 - 2
CLASS 150 - 1
There should be one record in the TASTE database for each record in the CODES database. I want to pull the sub-summary information into the TASTE database. Having difficulty getting my head around this. Many thanks in advance.
d