After a long time away from programming databases, last time was in filemaker 4! I want to bring myself back up to speed, to that end have decided to make a motor racing database.. so have set up tables of circuits drivers and results. easy now I come to making data entry easy and relationships.
What I would like to be able to do is pick a race say Australia, then pick the circuit Albert Park. then I want filemaker to look at my circuit table and say hey Albert park's track length is 5.303 Km. can I do this easily or will it require scripting?
Thanks in advance