Hi

I don’t need help resolving a problem on this occasion, but I would appreciate some help in understanding Indexing and Duplicates.  I have a main Audits table plus 7 clause tables.  They are related through the clause AuditID.  The FK AuditIDs in the main table I would have thought should be indexed with no duplicates (that’s what makes sense in my head).  But if I do that, the query becomes not updateable.

I would have thought that having no duplicates in the main table was the correct thing to do.  Or is there something I am completely missing here?

Thanks.

​Hi I don’t need help resolving a problem on this occasion, but I would appreciate some help in understanding Indexing and Duplicates.  I have a main Audits table plus 7 clause tables.  They are related through the clause AuditID.  The FK AuditIDs in the main table I would have thought should be indexed with no duplicates (that’s what makes sense in my head).  But if I do that, the query becomes not updateable.I would have thought that having no duplicates in the main table was the correct thing to do.  Or is there something I am completely missing here? Thanks.    Read More

​