Reply to thread

Message: [QUOTE="Amy Blankenship, post: 10201286"] I wouldn't put city, and zip into lookup tables. State is ok if you actually want to use it to help people enter the data, like with a Combobox or something. Why does the web page belong to the contact and not the business? Let's try something like this: tblContact ContactID FirstName LastName ContactTypeID LocationID (there are soome other things there that I don't understand, so they may belong here too) tblContactType ContactTypeID ContactTypeName tblEvent EventID ContactID EventType EventDate SendCard tblEventType EventTypeID EventTypeDesc CardToSend tblBusiness BusinessID BusinessName tblLocation BusinessID LocationDesc StreetAdd1 StreetAdd2 City StateProvince ZipPostal tblLocationPhone LocationPhoneID PhoneType PhoneNumber tblContactPhone ContactPhoneID PhoneType PhoneNumber tblPhoneType PhoneTypeID PhoneTypeDesc I think you could probably consolidate LocationPhone and ContactPhone somehow. For instance, you could create a contact that was the default for a location but wasn't any specific person and wouldn't have any events associated with it. HTH; Amy [/QUOTE]