| Author |
Message |
ChristianMuk
Newbie
Joined: 27 Sep 2012
Location: South Africa
Online Status: Offline
Posts: 15
|
   Posted: 10 Dec 2012 at 7:14pm |
|
Yes The salesPerson and Likelihood can be different which means there are Multiple of salesPerson and Likelihood and i tried adding the word Distinct after Select in the query there is no difference.am really out of idea for this issue and many thanks for your concern and help into this.
|
 IP Logged |
|
hilfy
Admin Group
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
|
Posted: 11 Dec 2012 at 3:36am |
So, the question becomes, how do you determine which sales person and likelihood to display? Or is it just the first combination, whatever that is, that you need? -Dell
|
|
|
|
IP Logged |
|
ChristianMuk
Newbie
Joined: 27 Sep 2012
Location: South Africa
Online Status: Offline
Posts: 15
|
Posted: 11 Dec 2012 at 6:53pm |
|
My salesPerson and Likelihood are first select when the user is entering the Info into the DB then save to the DB and there is only one salesPerson and one likelihood per ETNUMBER
|
|
IP Logged |
|
hilfy
Admin Group
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
|
Posted: 12 Dec 2012 at 3:21am |
I'm hearing conflicting information from you:
Yes The salesPerson and Likelihood can be different which means there are Multiple of salesPerson and Likelihood and
My salesPerson and Likelihood are first select when the user is entering the Info into the DB then save to the DB and there is only one salesPerson and one likelihood per ETNUMBER The first one means that there are multiple combinations and the second means there is only one. How you'll handle this is based on which statement is true. -Dell
|
|
|
|
IP Logged |
|
ChristianMuk
Newbie
Joined: 27 Sep 2012
Location: South Africa
Online Status: Offline
Posts: 15
|
Posted: 12 Dec 2012 at 6:45pm |
yes you are right i was confusing you, sorry for that. OK, here's the scenario there is a table called Sales and the salesPerson comes from there and there are Multiple SalesPerson in that table and there is another table Called Likelihood and the Likelihood comes from there again there are multiple of Likelihood in that table NOW, on the Tender table is where we found the ETNumber and one ETNumber can only have One SalesPerson and One Likelihood. and on the report all i want is to the ETNumber with its SalesPerson and its Likelihood respectively. SORRY again for the confusion
|
|
IP Logged |
|
hilfy
Admin Group
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
|
Posted: 13 Dec 2012 at 3:16am |
Since the link from Tender to Sales and to Likelihood is one-to-one, that's not where your duplicate data is coming from. Can Tender have multiple rows per ETNumber? Or do you have other tables in the report that have a one-to-many relationship with ETNumber that would be causing duplicate data? -Dell
|
|
|
|
IP Logged |
|
ChristianMuk
Newbie
Joined: 27 Sep 2012
Location: South Africa
Online Status: Offline
Posts: 15
|
Posted: 13 Dec 2012 at 8:00pm |
No a T ender can only have one row per ETNumber.but now i am starting to think since i have a customers Table which is link to the Tender Table with a one-to-one relationship and the Contact Table is link to the Customers with a one-to-many relationship might be the problem Relationships Cardinalities: Contact Table(ContactID(PK),CustomerID(FK)) -->One-to-many-->Customers Table(CustomerID(PK)) Customers Table(CustomerID(PK)) -->One-to-One-->Tender Table(ETNumber(PK),CustomerID(FK)) Tender Table(ETNumber(PK),SalesID(FK))-->One-to-One-->Sales Table(SalesID(PK)) Tender Table(ETNumber(PK),LikelihoodID(FK))-->One-to-One-->Likelihood Table(LikelihoodID(FK))
|
|
IP Logged |
|
hilfy
Admin Group
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
|
Posted: 17 Dec 2012 at 4:56am |
The one-to-many IS your problem. You need to determine how to limit the contacts to one record. -Dell
|
|
|
|
IP Logged |
|
ChristianMuk
Newbie
Joined: 27 Sep 2012
Location: South Africa
Online Status: Offline
Posts: 15
|
Posted: 14 Jan 2013 at 11:52pm |
HI Hilfy sorry i wasnt around for quiet a long time i went to see my family. i understand what you are saying but can you help me on how to limit a contacts to only one record?
|
|
IP Logged |
|
|
|
