Ask Your Question

List drop down selection only shows 1st list entry

asked 2016-07-14 15:45:44 +0200

Tyler gravatar image

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 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 Thanks

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-07-14 17:39:08 +0200

Ratslinger gravatar image

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.

edit flag offensive delete link more


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.

Tyler gravatar imageTyler ( 2016-07-21 18:30:11 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-07-14 15:45:44 +0200

Seen: 71 times

Last updated: Jul 14 '16