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!
On the linked record list view, you can swipe across any record to reveal the “Unlink” button. It’s similar to deleting a record, except it will just unlink it instead of deleting it. Also adding a proper to-one relationship is on my to-do list.
I have another problem with many-to-many link. I have a form with 207 records. One of the fields is a many-to-many link to itself(the same form). It was working fine, before I reached 200 records mark. Or maybe it’s not related. Anyway, I am trying to link a new record to existing one. I open Select Records window. The window freezes. I can see the records, but I can’t scroll. The loading wheel is shown. I can only close it. Other forms links (many-to-many, to the same form) work fine. Any thoughts?