Hi Aleskey,

It turns out that not all records will have a customer_number.
(I have no control over the data unfortunately !)
Is there a way to add a field a hold a unique number that will propogate to the child tables that I join to.

Thanks
Carmel