Assigning multiple values to one record.
Basically the company I work for has asked me to incorporate another section to their database structure.
We have another load of clients joining us (around 750) and they want to assign each of these 750 new clients 10 unique voucher codes. The unique codes must be unique, not only to each record to each other code.
I have set up an external way of generating these codes at mass. I just need to know the best way to set things up so that I can attach ten unique codes to each record of a client. I was considering 10 extra fields but I think that would be very bad in the long run.
Thanks in advance.