Trying to make a WO tracker and I have a many to many relationship shown in a subform table as shown in the directions at https://www.youtube.com/watch?v=GYawYO8u3_s.
When I add entries from the drop down list the table only displays the first drop down entry; in my case “Non-Addressed Location” when I close and reopen the form the table shows the entry I actually selected “4 Bob Street”
I need my table to display what I selected as I selected it like in the video. Now, the video he is only using 2 or 3 drop down options where I have 12000± Addresses so that could be the issue as well.
using Windows, embeded database (HSQLDB), Libre 5.1.4.2
Thanks
The first thing you should do is create a backup copy of your .odb and a backup of the backup and make sure they all work. The reason is simple. An embedded DB has a problem with data and it can easily be corrupted when the .odb file is extracted or compressed during the opening or closing of the .odb file especially with larger amounts of data (12000 addresses).
Then look at this link (click here) to split the database (separate the data from the .odb).
As to the question, the ideal situation is for you to post a copy of your .odb with a small amount of non personal/confidential information. There appears to be something in your settings which is causing the problem but I cannot replicate the problem. If not possible, you should (using a copy) delete the majority of data from the Addresses (or copy/paste the table without data) and using a small amount of Addresses see if the problem remains. If so, delete the subform and set it up again.
If the problem still persists, either post a sample .odb or more details on the subform Data properties and the table column listbox Data properties via an Edit in your original post.
Sorry I have not checked back on this, I thought I got notifications but I guess not, anyway the issue just went away when I went back to it. Maybe the list was still loading into memory or something, not too sure. I have since took it into a postgre database using libre as the front end. I will probably be adding more questions soon. Thanks for getting back to me.