I had a technicians table with a pk, and all of our technicians names, and our main table that has a relationship between an fk in the main table and the pk of the technicians table.
I also had a dropdown box with a value list from the technicians table. The first field was the pk of the technicians table and the second was the technicians name. I had it set to show value from second field only.
This was working for the longest time, then recently the dropdown still shows the technicians names, but when you select one of the technicians, the pk populates the dropdown, not the technicians name, which it did before.
Why would this suddenly change?