Screen shot: www.jcpythons.com/screenshot.png
in this screenshot im adding recors of taxonomy classification for animals such as reptiles etc.., each record i add to this table can be used to represent the family, species, sub species etc... of each animal in another table, they are related by a field called "HP ID" which is in both tables. so when entering a new animal in my main table ("HP Main") the user comes to the classification fields where all they have to do is click a button which opens a new window of my taxonomy layout and once they choose the classification that suits there animal it copies the info from that record and paste it into the appropriate fields on the other table "HP Main"....However! when i make the changes to a records in the taxonomy table it doesnt automatically make the changes to therecords that are using that data in the fields.
im not sure if thats even possible, but i would think there must be a way of some sort?
The other thing im trying to do is change the way adding/editing and viewing the taxonomy table records looks, as you can see from my screenshot in the url above (couldn't get the attached photo to show). you'll see how i have each field used as a drop down list and i would really love to have the form work as a combination, what i mean is i select the first field when entering a new record, and lets say i choose for the "Boidae" for the Family field, then only Species that follow under that class should appear in the drop down list field below named "species" and so on and so on. Im only a couple weeks into filemaker, but learning lots on my own and learning lots here in the forums, i try searching for my answers but sometimes a lot of the things im trying to do is just hard to guess what to search for here in the forums. Hope someone knows what im talking about with what im trying to do lol.