In this table I have a list of plant names (taxa) plus other information about the plant's habitat, etc. Plant names frequently change, and the old name is considered a synonym, while the current names is the "accepted" name. Accepted names can have multiple synonyms because the names have changed several times.
I want to show only accepted names in the main Taxa Table view. If a name changes, the currently listed name will become a synonym. I want to be able to automatically separate synonyms into a different view or table once I have designated them as synonyms. BUT the new accepted name will need to have all the same associated information (habitat, etc.). The synonym view/table can just be a few fields with the old name and related information, but it will need to link back to the accepted name.
Example: Mariosousa willardiana is now Mariosousa heterophylla. How do I replace the new name with the old name but still keep a record of the old name as a synonym and remove it from the current view or table into a separate synonyms view or table? And how to I keep the new accepted name linked to all of its synonyms so they're easy to see? I want this to be as automatic a process as possible.
