AnsweredAssumed Answered

Relationship help

Question asked by ecohomes on Feb 2, 2017
Latest reply on Feb 3, 2017 by philmodjunk

Hi guys,

Sorry I do not know the terminology of what I need.

I am trying to setup a database to record some info on postcodes. What I need to do is, each supplier can have 4 types of lead (back data, profile, survey, 2nd use). I have two tables for suppliers and postcodes already. I also have 2 join tables for many to many relationships. I need each field in the postcodes database to be able to store a count for each supplier's lead type.


Supplier    - Lead Type - Postcode - Count

Supplier A - Back Data - AB            - 20

                                     - BB            - 155

                                     - CB            - 30


                     Profile     - AB             - 55

                                    - BB             - 27

My problem is with the way I have set the relationships up currently. When I add a count for a postcode it adds that count for all suppliers. I need the postcode count to be specific to each supplier and lead type.

Can anyone tell me what I need to do to get this working correctly? I have attached a screenshot of my relationships.