i am working on a lineage (pedigree) type of database. what i would like to happen is that when i click on a field (showing dog's name), it would bring me to the records of that particular dog. for example, a record contains dogA, dogB is dogA's sire, dogC is the dam. if i click on dogB, it would bring me to dogB's main record showing dogB's sire and dam and so on.

i thought all i needed to do was to get to find mode and get related records but i could not get any script to work.

i probably need a sample script for this. thanks for any help in advance.

You have not mentioned what version of FMP you are using. On the basis of what you have said ( and how you do it depends on version) you need to set up two self relations on your file one matching Sire to Dog and the other matching Dame to Dog. Then set up the fields Sire and Dame as buttons with a go to related record in the appropriate relationship. I am attaching an extremely simplified and unrealistic demo in fp3 format which you should be able to convert to whatever version you have.

Dogs.zip

Thanks SlimJim. As usual, I was making things more difficult than it should've been. Works fine.