If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Designing a client database
Hello all,
I am trying to design a database to store the information of our clients. I would like to get some inputs from you guys on the design. Also whether anyone knows of a web site that I can go to download a sample client database. I am facing some difficulties on the design. I will discuss my difficulties below. Before I share with you my difficulties, the way we have our client number is different from most firm. Our client number is not automatically generated by Access. Instead we come up with a new client # whenever we add a new client. The structure of our client # is, for example, "1234.01". The first 4-digit represents the family and the last 2-digit represents the clients in the family. For example, if we do a job for both father and son, the client # for the father is 1234.01 and the son is 1234.02. In the past, the database was wide-open, and people would go into the table to add a new client. For example, if it is a new family, people would look up the whole table and come up with a new client # by picking the unused client #. That whole process created big problems because there were no controls on the database. Now I am trying to re-design the database where people use the forms to add new clients or modify existing clients. The difficulties that I am having is how do I design it so that: 1. the user can easily come up with a new client # for a new client 2. the user does not end up creating the same client with a different client # Thanks in advance for your help. Any suggestings or comments are greatly appreciated. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I need help populating a field based upon another table | Landywednak | General Discussion | 11 | January 14th, 2006 09:27 PM |
Toolbars, Drop-Down Menus | Rick | New Users | 1 | September 21st, 2005 11:17 AM |
How do I link a client database in Access, to Outlook's contacts? | Shine | Contacts | 1 | June 12th, 2005 11:29 PM |
Networking Database | Gary | General Discussion | 1 | June 9th, 2005 04:53 PM |
Database Window Gone | DaveB | General Discussion | 2 | July 29th, 2004 12:24 AM |