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 for to know how i would do this
Database Design
- Thread starter Mega1
- Start date
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
now contacts do not have to be with any company. but a company could have more than one contact.
Hope this helps
Dreamweaver
Well-known member
- Local time
- Today, 08:08
- Joined
- Nov 28, 2005
- Messages
- 2,462
I really don't know If it would help but take a look at my contact manager system you could always use some of the tables in the bk end and hopefully will point you in a direction.
https://databasedreams.createaforum.com/address-book/
https://databasedreams.createaforum.com/address-book/
- Local time
- Today, 02:08
- Joined
- Feb 28, 2001
- Messages
- 30,548
My usual advice for someone in this stage of planning is to make a paper diagram or other representation of the work flow. If you can't build the diagram on paper, you are not yet ready to build it in Access. Once you actually HAVE a diagram and you think it is correct, you just built a roadmap of how to build your code and what your tables have to contain to make things happen like you want.
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 company pick main contact for this case
create new folder (for files name of client)
select case type
create case number
create new folder(case number)
select who case is to
pick letter to write (from list) word will open with info filled in
letter recorded when created and by who
also i will need a timer for each case to count how much hours have been worked on
this what i got so far and i know it needs a lot for prep work before i start.
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 company pick main contact for this case
create new folder (for files name of client)
select case type
create case number
create new folder(case number)
select who case is to
pick letter to write (from list) word will open with info filled in
letter recorded when created and by who
also i will need a timer for each case to count how much hours have been worked on
this what i got so far and i know it needs a lot for prep work before i start.
Dreamweaver
Well-known member
- Local time
- Today, 08:08
- Joined
- Nov 28, 2005
- Messages
- 2,462
are you referencing personal/business As in a person like me or a company if so both should have entries in your address book as they are both clients with there own details and both pay you can deal with the rates later basics first.
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..
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..
Dreamweaver
Well-known member
- Local time
- Today, 08:08
- Joined
- Nov 28, 2005
- Messages
- 2,462
This is how I deal with address book entries
As you can see I just have a customer name which might be Mr Jones Or as below jolly crumpets you add the contatc number(s) in the subform make it nice and simple as thats what I'm trying for in that project.
hope it helps mick
As you can see I just have a customer name which might be Mr Jones Or as below jolly crumpets you add the contatc number(s) in the subform make it nice and simple as thats what I'm trying for in that project.
hope it helps mick
Attachments
- Local time
- Today, 03:08
- Joined
- Jan 23, 2006
- Messages
- 15,499
Mega1, you may get some ideas from the data models at Barry Williams' site.
See those in the Law Enforcement area.
As Doc suggested, make sure you have analyzed and clearly understand the requirements, a few examples of the outputs being requested can help identify hat must be captured, stored, massaged etc. I agree that diagrams are great tools for getting the logic and relationships organized.
This little game may also be useful.
Good luck with your project.
See those in the Law Enforcement area.
As Doc suggested, make sure you have analyzed and clearly understand the requirements, a few examples of the outputs being requested can help identify hat must be captured, stored, massaged etc. I agree that diagrams are great tools for getting the logic and relationships organized.
This little game may also be useful.
Good luck with your project.
