darkarchon
Technical User
hi... just 2-3 days of mysql here... i want to set up a database... it might have about 50-60 columns... basically for the finance industry we have to list creditors for each of our clients. some clients have 4 creditors. some have 12. some have 15.
so what is the best way to design this? just a table with 60 columns in this format:
client creditor1 creditor2 creditor3 creditor4 etc...
basically i am looking if there is a way to create "dynamic columns" or some sort of linked list? or link other tables? i want to be most efficient in my design and if i leave space for 12 creditors for each client then i will have alot of null values.
your comments are helpful and really appreciated.