Now, if I make the customernumber the pkey, unique, or otherwise, and use the shiptonumber instead for shipto addresses, then the customernumber can no longer be unique, and it can't be null. Nor can it be used more than once as a unique key, even if it's set to Not Null = No. So what now.