Unanswered: No further entries of a value in table
I have a table which stores phone numbers of a customer in a table.
Say this table is as below
CustomerName - PhoneNumber
Customer 1 - Phone number 1
Customer 2 - Phone number 2
Customer 2 - Phone number 3
Customer 3 - Phone number 4
What would be the best approach to prevent adding another entry against Customer 2. I should be able to add new customers and add multiple phone number against all other Customers. The restriction should be only against Customer 2.
Any idea in the right direction will be much appreciated.
Brett this is a dirty workaround to stop users from adding charges that they cannot map to an internal account. Now they will have to put in the effort to correctly allocate charges to the right customer.