I haven't decided yet, whether "I got it" or that I'm on the verge of epiphany.
I've got three tables planned to create a "customer" entity ("customer" is what will be shown on the top of the form... basic information only, I'll worry about the other stuff (phones etc) later)
So I have my first table:
customer (customerID, customername)
Seeing how I have basically two types of customers; companies and people that suggests two more tables, as well as adding an additional boolean field to my first (this will help direct things as to which table to enter the data to.)
customer (customerID, customername, boolean(company y/n?)
company (companyname)
person (last,first,mi)
later on down the line, when I get to the point where the customer specifies a contact (either a company has a contact name, or a person names another as secondary contact) I can create an association table that links the two.
associate (customerID, person)
That sound about right?
~W