Friends - I am working on revmping a MySQL database set up by a predecessor and need to do the following
The database is a list of customers, basically. Some of those customers are "distributors" and others are "end users"
I need to be able to associate customers with distributors, meaning, one distributor might oversee 20 end users so I want to add a means of associating those 20 users with that one distributor.
Whomever set this SB up initially did, at least, set up a unique ID for each entry, "uniqueid". Is it reasonable to add a field to this DB called "associations" that then collects uniqueid's for each of the associated end users? So over time, "Dist ABC" would have, in the "associations" field, 1234 ,1324, 2873, 2339, etc that I can output later?
Or would it be more advantageous to have a completely different table that collects that information?