This was a strange one that I had to go to Infor Support to resolve. I used the SQL Tables Form to set up a brand new table, generated a new primary key, built the IDO, and then created a form bound to the IDO.
(Yes, I probably could have done it much faster with the New Data Maintenance wizard, but old habits die hard.)
What was weird was that every time that I tried to save data using this form, I got everyone’s favorite error: “Object Reference Not Set To Instance of Object” I took it to Infor, and they told me to delete the IDO, delete the key constraints, recreate the IDO, then add the key constraints back in. Sure enough, that solved the problem. Infor seems to know this is an issue, but I haven’t found a KB on it yet. Hopefully the incident I have in will become a KB.
Thank you so much for this. I was going crazy over a simple two column mapping table with FKs….
LikeLiked by 1 person