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?