I searched for about an hour on this and couldn't find an answer that worked for me.
I have one main table that joins to several 2 column tables (users, status, priority, etc.)
I have comboboxes for each of these items to select from. All of them but one works. I have copied and pasted a working one. Double and triple checked table structure. I am sure I have a primary key and a unique index on my server table, but I can't seem to find out why this particular combobox will not let me update it.
I have one function in this project called getProjects that shows the stored procedure code.
I attached a test copy, but converted the server tables to local tables. Any help on this?