Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 26th, 2003, 07:54 PM
Authorized User
 
Join Date: Jun 2003
Posts: 47
Thanks: 0
Thanked 0 Times in 0 Posts
Default Name issue with table

I am setting up a db with customer information. I have in the customer table FirstName, MI and LastName. Some of my customers will be companies with only one name.

I could set up a field called CompanyName and enter company name in it but I will have to deal with two names in my reports. I am not sure of the best way to resolve this.

Can someone suggest a way to design my db to take this into consideration

Thanks
 
Old December 27th, 2003, 12:32 AM
Friend of Wrox
 
Join Date: Nov 2003
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default


In consideration; ask your self how valuable will it be that you have as much information as possible about your customer. Capturing this information depends on how you do business, is it more for the individual within a company or with a company and you deal with one individual. In either case capture both in the event either changes you have both to correspond to. As far as your report; be more specific as to where you think your problems may be. A report can be as complex as you want it to be. In other words present only what you do or do want to present. I hope this information helps.


 
Old December 29th, 2003, 11:41 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Jemacc is correct in asking you to evaluate what's important to you; but in general, if you're doing business, I strongly recommend that you have both person and company in your table. If the person you're dealing with is representing him/herself, you can always leave the company field empty. However, if you're dealing with a company, you always want to know the name of the contact person. You would never leave that person's name out and just put a company name. You're asking for trouble if you do. Always have a contact name and phone number or e-mail address.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
 
Old December 29th, 2003, 11:48 AM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have a contact database but the information is broken down respectively such as:

tblCompany
CoID
CoName
CoStreetAddress
CoCity
CoState
CoZip
CoPhone
CoFax
CoURL

tblPeople
PeopleID
FirstName
MI
LastName
Email
CellPhone
WorkPhone

Then you have a join table called tblPeopleCompany where you state what people are related to what company and the effective date:

tblPeopleCompany
CoID
PeopleID
EffectiveDate

HTH,

Beth M





Similar Threads
Thread Thread Starter Forum Replies Last Post
Form & Table issue Grafixx01 Access 7 April 30th, 2007 08:13 PM
Ch10 - issue with insert in log table Cata BOOK: Professional SQL Server 2005 Administration ISBN: 0-470-05520-0 0 February 15th, 2007 05:17 PM
navigation table spacing issue obfuscaTed HTML Code Clinic 2 January 19th, 2007 05:14 PM
Plain text table style issue[?] hubba09 XSLT 0 April 13th, 2005 05:51 AM
Linked table issue leehambly Access 2 November 26th, 2004 01:28 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.