Hi, I've built a web page with two html tables, one with the heading Users and the other with the heading Items & Artists, showing data from a Microsoft Access database. Each html table accesses a separate Access table within the same database. Each html table also allows the user to edit, delete from or add to its Access table. After building the Users table, with its associated form and action files, I made sure it worked for all three operations. I then built the Items & Artists table and its associated form and action files by copying the code in Users and changing relevant names (like column headings etc.). However, when I try to edit the data in the Items & Artists html table, I get the following error message: "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship" (tho the delet from and add to operations work OK). This puzzles me greatly, since the code used in the Items & Artists table, form and action files is identical to that used in the Users table, form and action files, with the sole exception being table, variable, form, file and heading names (ok, that's quite a few names, but the underlying code structure is the same). What should I be considering as a possible cause of the problem? Sincerely, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft & More Online Store: http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
