I will try and make myself more clear, I apologize for any confusion. Again, if this logic seems off base- please advise.
I would like to set up the tables so that the data works under the following assumptions:
Every contact has a company and an address; the company and address information is...
The main part of my membership/registration database deals with contacts in three tables:
Contacts: CID(pk); companyID; addressID; firstName; lastName; etc
Company: companyID(pk); companyName
Address: addressID(pk); Address1; Address2; City; State; etc
The db has people(same company...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.