Question about duplicate phone numbersLink Brent R 5 months ago
Good Morning Richard, I have a database that we have been keeping track of Names and phones numbers over the years the peoples phone numbers get handed over to other people and they become someone else phone number, so now in the database I will end up having the same phone number for 2 people but the older one is now invalid, but we might not have a new number for the older person is there a way to search for the number first to see if its in the database and remove from that record before assigning to a new record?Read More...
Reply from Richard Rost:
Sure. There are many ways you could go about that. You could have a separate phone number table which is related 1-to-many with customers. This way a customer could have multiple phone numbers. Then a search would bring up the customer associated with that number.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.