hch
Member
I have a custom table (with primary key composed of 6 columns), view with all columns, and a form over it. When I try to modify one of the non-key fields via the form, I get a duplicate key error. I have tried this with a header detail form and headerless detail form and the error is consistent. I can add a row, but cannot modify. I have looked at the logs, found the keys it is trying to insert, and put them into a SQL statement. Only 1 row is returned. Any ideas?
Thanks!
E91, SQL DB, Windows
Thanks!
E91, SQL DB, Windows