AnsweredAssumed Answered

Many to one relate and calculate issue

Question asked by benchwrm11 on Jul 25, 2012
Latest reply on Jul 27, 2012 by benchwrm11

I've built a database for an animal tracking study. I have one table containing the Animal ID and a Flag ID marking the location of each animal I relocate. In another table I have Flag ID and the location of the flag. I'd like to get Filemaker to look up the last Flag ID of each animal, and calculate the distance moved (simple subtraction).

 

Currently, the Flag table and Recapture table are related by Flag ID.

 

Is that something easily accomplished?

Outcomes