I am trying to do "many-to-one" linking, as in a tree database where each tree specimen points to a species, and there are of course more specimens than species. I know I can just have a field in the tree record to insert the species name, but I really want to display the complete species record when I click on that field, not just see the name.
I implemented this approach using "many-to-many" linking, and it works just fine, with one serious drawback: If I make just one error in creating a link, I am unable to remove that link - I must remove ALL links in the table. So obviously I am not going to take that risk.
Overall, a very valuable app. Keep up the good work!



