Hi,

I have a table, MSAMedicalServices, that has the following fields:
SER_ClinicFK I
SER_Invoice I Caption "Invoice"
SER_lVoid L

And a CANDIDATE key, CLINICINV, defined as follows:
Expression: BINTOC(SER_CLINICFK)+BINTOC(SER_INVOICE)
Filter: .NOT.DELETED().AND..NOT.SER_LVOID

This works fine, at the clinic installation as i can have multiple invoice entries for a clinic that are voided, but only 1 non-voided invoice for the clinic.

No problem.


I have an Export/Import scheme, however, that updates this table at Headquarters, and here is the problem.

The Import inserts the new entries into a view, v_MSAMedicalServices, and when the Tableupdate() is called for v_MSAMedicalServices, i get the error:

Uniqueness of index CLINICINV is violated

I'm trying to figure out how to handle this...any input is appreciated. Thanks, Jill