questions and answers
can you explain what kind of data each table holds and the relationship between them ?
RE: One is members database. Second is a division of their company
is the naics table essentially a reference table ?
RE: It is a dropdown menu of all their divisions
Table Name: naics
naicsNum, naicsTitle
can members hold more than one naics code ?
RE: Members can have up to 6 divisions. If you look at the select area you can see that serviceone, servicetwo, etc. are part of the members table and those would be the divisions.