Go Back   Access World Forums > Microsoft Access Discussion > Theory and practice of database design

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-02-2018, 05:21 AM   #1
Albion
Newly Registered User
 
Join Date: Apr 2018
Posts: 5
Thanks: 3
Thanked 0 Times in 0 Posts
Albion is on a distinguished road
2 contacts = 1 client

i have been looking and doing several searches on the threads to no avail.

my database creates a contact datasheets for everyone (employees, clients etc).

in the event a client making an order is made of two contacts, how do you organise that? if threads exists, happy to be redirected, if not what do you suggest?

Many thanks in advance!

Albion is offline   Reply With Quote
Old 04-02-2018, 05:30 AM   #2
The_Doc_Man
AWF VIP
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 11,479
Thanks: 41
Thanked 1,001 Times in 912 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: 2 contacts = 1 client

Here is the question: "Made of two contacts." How do you mean that? Your description is a very simple statement that condenses your meaning a bit TOO much.

My thought here is that you need to search for some topics using this forum's search function, which is 3rd from the right in the ribbon near the top of the page just under the little box that tells who you are.

Topic #1 - database normalization - with the end goal of learning about many-to-one relationships and one-to-many relationships.

Topic #2 - business model - with the end goal of learning about how to better make your database a "map of the territory" so to speak.

Topic #3 - junction tables - with the end goal of learning how to manage what we call a "many to many" relationship. For instance, if the same contact can lead to two orders and (as you state is your problem) an order can originate from two contacts, then you have a many-to-many relationship.

OK, having made the suggestions, I SUSPECT that your problem is that your contact info is in the same record with the order info and you don't have two contact slots in that record. IF that is correct, you need a separate contact list. Probably need a separate client list if you have repeat business, too.
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
The_Doc_Man is offline   Reply With Quote
The Following User Says Thank You to The_Doc_Man For This Useful Post:
Albion (04-02-2018)
Old 04-02-2018, 10:39 AM   #3
Albion
Newly Registered User
 
Join Date: Apr 2018
Posts: 5
Thanks: 3
Thanked 0 Times in 0 Posts
Albion is on a distinguished road
Re: 2 contacts = 1 client

Hi there! thanks for the answer and the suggestions. I will check now.

What i meant was: when a couple buys a good (ie car), i want to record both their names and details as individual contacts (Person Table) as they are buying in joint name. But together they are the 'client' on the the order (Customer sheet- which records Person + Role (ie Client)). Does it clarify? i am not sure to be explaining clearly!!

Albion is offline   Reply With Quote
Old 04-02-2018, 10:47 AM   #4
The_Doc_Man
AWF VIP
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 11,479
Thanks: 41
Thanked 1,001 Times in 912 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: 2 contacts = 1 client

I addressed this in the other thread that posted. Since that thread is also on this subject, I will not further answer in this one. No need to reinvent wheels.
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
The_Doc_Man is offline   Reply With Quote
Old 04-02-2018, 11:00 AM   #5
Albion
Newly Registered User
 
Join Date: Apr 2018
Posts: 5
Thanks: 3
Thanked 0 Times in 0 Posts
Albion is on a distinguished road
Re: 2 contacts = 1 client

Sorry! I had not seen your answer to my other thread! It helps a lot. Clearly not figured out the forum ways yet!

Albion is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a table to Track Monthly Client Contacts dmm1977 Tables 1 01-10-2017 11:42 AM
Linking Clients and Client Contacts to Addresses harringh Tables 1 01-25-2011 05:36 AM
MS Contacts Template gemma-the-husky General 2 03-05-2010 07:44 AM
New db for contacts and invices waterdamage General 2 01-13-2007 08:41 AM
[SOLVED] Current Client/Prospective Client Database Razieluk Tables 4 11-09-2005 08:28 AM




All times are GMT -8. The time now is 07:00 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World