Also, you have your terminology a little mixed up. The key field of a table MUST be unique. So, status cannot be the "key field in the Customer table," because it is not unique in the customer table.
Drew
I'm sorry, I thought 'foreign' was understood, just as 'primary' is in your statement.