This should be a simple fix.
Here is the breakdown for my problem. I need a customer db with all the usual info. I need to add a field for storing a code (example: PO for police officer TE for teacher) some of the customers are both PO (police officers) and CG (community groups). I need a fix so that each customer can have multiple codes.
I could add each field to the customer record and have a yes/no field.
I could have another table with a customerID and a CustomerCodeID that links to a table with CustomerCode Information.
I could allow duplicate records and remove duplicates with a query when I need to do a mailing.
These are some of my ideas...what are yours?