Recent content by Mega1

personal is a person business is a company generally a person has only one address and a business can have more than one address when i select a person only one address will be there if i pick an company will pick which address i will use for this case ie. Main, site1 site2..

i have never done a digram for a database before i have always just built them. this database does need planing I think trying to build a case management system for a solicitors. if we go with the flow of how it works new case pick client (personal/business)if none create new if...

ok you setup a case a case can be either a company or a contact but if i pick a company then for this case i have to make someone the person to talk to. now contacts do not have to be with any company. but a company could have more than one contact. Hope this helps

i am creating a database i am going to have three tables one for contacts, business, and case. i want to be able to pick the business in the case at the same want to pick the default contact for that case from the business. each case can have the same business but a different contact. looking...