Jump to content

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


This topic is 7289 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 7289 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.