If you want to create a foreign key, it must reference either the primary key, or a field with a unique constraint.
If you want to display the customer’s name, make the foreign key reference the CustomerID, and display the results with a join.
If you want to create a foreign key, it must reference either the primary key, or a field with a unique constraint.
If you want to display the customer’s name, make the foreign key reference the CustomerID, and display the results with a join.