Re: How to do agregate calc on external field?

[Alan H]

The discussion in the foregoing post has gotten too hard to follow, and I wanted to post an example of the solution suggested by Espringer.

The task is as follows:

You are given a database of car models. You don't want to touch that database because it is used by others, and you don't want to add cruft. You have a data of people and car ownership, and you want to display:

1) For every person, the number of cars he/she owns, and which models

2) For every model, the number of owners of that model, and which owners

I was stuck on how to do (2). The solution is in the attached sample file. Unzip and open People.fp7. Sorry about the ugly design

CarsPeople.zip

[ESpringer]

cruft... [looking up, flip, flip] Wow! Thanks for the fancy technical vocabulary!

/kruhft/ [very common; back-formation from crufty] 1. n. An unpleasant substance. The dust that gathers under your bed is cruft; the TMRC Dictionary correctly noted that attacking it with a broom only produces more. 2. n. The results of shoddy construction. 3. vt. [from `hand cruft', pun on `hand craft'] To write assembler code for something normally (and better) done by a compiler (see hand-hacking). 4. n. Excess; superfluous junk; used esp. of redundant or superseded code. 5. [university of Wisconsin] n. Cruft is to hackers as gaggle is to geese; that is, at UW one properly says "a cruft of hackers".

http://dictionary.reference.com/search?q=cruft