I have two tables (see below). I am trying to get my power-pivot to match what I did in Access, but it is not working.
It is a one to many relationship. One Project can have many Services.
Here is what I want vs want I have.
http://oi65.tinypic.com/10p2cg7.jpg
This is the first table.
<colgroup><col><col></colgroup><tbody>
</tbody>
This is the second table.
<colgroup><col><col></colgroup><tbody>
</tbody>
Thank you
It is a one to many relationship. One Project can have many Services.
Here is what I want vs want I have.
http://oi65.tinypic.com/10p2cg7.jpg
This is the first table.
Company | Project_ID_Table1 |
Steve's Company | 1 |
Steve's Company | 2 |
Steve's Company | 3 |
Steve's Company | 4 |
Steve's Company | 5 |
Rick's Company | 6 |
Rick's Company | 7 |
<colgroup><col><col></colgroup><tbody>
</tbody>
This is the second table.
Service_ID | Project_ID_Table2 |
Service_001 | 1 |
Service_002 | 1 |
Service_003 | 2 |
Service_004 | 3 |
Service_005 | 4 |
Service_006 | 5 |
Service_007 | 6 |
Service_008 | 7 |
Service_009 | 7 |
Service_010 | 7 |
<colgroup><col><col></colgroup><tbody>
</tbody>
Thank you