Value list selection breaks

[InHouseDev]

Hi, all! I find this issue hard to google, so I bring it up here. I'm sure many people have had the same issue, but I could not find any thread on the matter.

I have several value lists made from tables, where the primary key is stored but some other secondary field is displayed in popup-menus. Quite often, the choice is removed, and in it stead, a five digit number appears. The number is not the same as any primary key value in the table behind the value list. I then have to manually re store the choices. The relationship is also broken.

Can anything be done to prevent this from happening?

Thank you for your help