Help with relationships!

[Chatholo]

Hi there,



This is what I am trying to achieve:
Product A / Business Unit 1 / Number of heads
Product A / Business Unit 2 / Number of heads
Product A / Business Unit 3 / Number of heads
Product A/ All business Units/ Total number of heads


The data comes from two different tables:
Table 1 provides the number of heads as a total for all business units within the region:
Product A/ Region A / number of heads
Product B/ Region A/ number of heads


Table 2 provides the spolit of business units in the region:
Region A / Business Unit 1
Region A/ Business Unit 2
Region A /Business Unit 3
Region A / All BU

I would like to have my table1 match each line called all business units and then through a form I will have the user manually split this total by business unit. But at the moment with every relationship I have tried, I get the total heads on all business units line, how can I do to make it hit only the total line and have the others empty?

Thank you for your help!!!
C.

[orange]

I think you have to step back and ask a few questions, then get some clear answers if readers are to help.
What is a Product? You show ProductA, is there a ProductB,...ProductX?
What is a Region? You mention RegionA, do you have RegionB,,,RegionX etc?
What is a BusinessUnit....?
What constitutes a Head?
Do you have subRegions?
Step back from Forms and HOW implementation could occur, and/or presentation details.
Focus on WHAT your data/entities is/are telling you.

For reference, here is a tutorial to help you identify the entities in your business and how they relate to each other. It may give you some ideas on addressing the data and designing your set up, before getting too deeply involved in Access constructs.
http://www.rogersaccesslibrary.com/T...lationship.zip

Good luck.