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.