get content of a field in a different table (FM7)

April 13, 200421 yr

HI,

I am using FM7 and I have a file with different tables. One table contains multiple experiments with 40 result fields (Each experiment has 36000 entries (rows) and is identified by an additional field that contains an experiment identifier, that is the same in the 36000 rows of each experiment). I would like to create kind of a "lookup" field in a different table, that should contain one result field of a specific experiment (eg. field experiment identifier= "exp3"). I tried some calculations but none worked so far.

Any help is very welcome!

Joern

FileMaker Version: Dev 7

Platform: Mac OS X Panther

April 14, 200421 yr

Well, you need to create a relationship between the two tables, probably based on your experiment identifier. You do that by drawing a line between the two in the third pane of the "Define Database" dialog.

So, in the second table you would have a single record with "exp3" and in that record you could perform calculations like, Sum(experimentData::result1) and get a total over all 36000 records that matched "exp3".

Hope this helps.