Forum Discussion
VBA Code & Relationship setup to populate form fields on After Update event
Hi, Thanks in advance for any help. This involves a little VBA code and three MS Access tables. 1) SR. Technology Officer (tblSTO), 2) tblProjects, 3) tblDeliverables. Among other fields,the STO tabl...
when you look at the indexes - you will at first see that I haven't set the composite indexes to be unique. So currently you can create duplicate records.
Try that first, then delete the duplicates, set the Indexes to be unique and then try to create duplicates. You shouldn't be able to.
So the main points are -
Get your table structures and relationships right
Use indexes, not compound PKs, to enforce business rules