Thanks everyone for your help.   I've implemented Georgedo's solution and it works fine.

Thanks for replying.  By Primary I mean unique.

To clarify:

1). the unique index in table one is customer, date, refno.

2). the unique index in table two is customer, date, refno,