Because every sales order needs to have a customer, define the one$-$to$-$many relationship between the primary Customers table and the related Sales table. Select the Enforce Referential Integrity option and Cascade Update Related Fields option for this relationship.