Hi All,

We would like to have a Primary index key that is based on more than 1 field. i.e. Po_no N(11), po_ln_no N(11). I know po_no + po_ln_no will SUM() the 2 columns. We tried PADL(TRANS(po_no), 11, '0') + PADL(TRANS(po_ln_no), 11, '0') This does not work. But we have no idea why not. We keep getting an error saying the uniqueness of the index has been violated.

Can it be done? If so, what did we miss?

VFP6 SP5 - The database is a standard VFP '.dbc'

TIA
Mike