title: Excel 2013 PowerPivot - 3 Tables, relationships not registering
body: <p>I am trying to build an excel based database for tracking of equipment from supplier to delivery point. Although Excel 2013 has solved the majority of my issues with PowerPivot and the Data Models, however some of my relationships aren't registering.</p>
  
  <p><strong>Design</strong></p>
  
  <p>Basically, I have the following tabs and information:</p>
  
  <p>Table: Equipment</p>
  
  <p>Columns: Identifier (Unique), Package No, Equipment Description, Area</p>
  
  <p>Table: Packing</p>
  
  <p>Columns:Identifier, Packing ID</p>
  
  <p>Table: Freight</p>
  
  <p>Columns: Packing ID, Packing Type, Dimension</p>
  
  <p><strong>Reasoning:</strong></p>
  
  <p><strong>Equipment</strong> - Each piece of equipment has a unique identifier (Identifier) that allows for tracking purposes. The delivery point looks for equipment and can track using this ID, as can purchasing. The remaining information is required for contracts and for installation.</p>
  
  <p><strong>Packing</strong> - Equipment is 'packed' into boxes, pallets, or other freight containers. This is separate to the Equipment table as multiple pieces of equipment can be 'packed' into freight containers, or a total number of pieces of equipment can be split across several freight containers.</p>
  
  <p><strong>Freight</strong> - This is the spreadsheet that tracks the 'freight containers', be it boxes, pallets, or containers. This is required for when the freight is in storage or in transit, to easily identify what it looks like and to assist in locating equipment.</p>
  
  <p><strong>Problem:</strong></p>
  
  <p>The relationships aren't working in the PowerPivot. I have a many to one relationship between Packing and Equipment, and Packing and Freight, but I cannot get the Packing pivot table to recognise these relationships, so, when I create a pivot table based on Packing, and try to feed in one of the other columns from either Equipment or Freight, it just adds all the information, rather than the specific information.</p>
  
  <p><strong>Question:</strong></p>
  
  <p>Is my structure not effective for a relationship? Am I building the pivot-table incorrectly?</p>
  
  <p><strong>Previous Searches</strong></p>
  
  <p>I've looked on Stackoverflow, and there are some things that seem similar but seem to complicated for this question.
  <a href="https://stackoverflow.com/questions/28585349/powerpivot-relationships-not-working-multiple-tables">PowerPivot Relationships Not Working - Multiple Tables</a> (relates to creating unique ID's, but I already have these, so not applicable)
  <a href="https://stackoverflow.com/questions/29343667/laravel-4-2-sync-multidimensional-array-in-pivot-table">Laravel 4.2 Sync multidimensional array in pivot table</a> (unfortunately I don't know or use VBA, so this confuses me but I think it's too much designing for what seems to be a simple problem)
  <a href="https://stackoverflow.com/questions/25913739/three-tables-in-pivot-laravel">https://stackoverflow.com/questions/25913739/three-tables-in-pivot-laravel</a> (this appears to answer the question, but I couldn't get it to work, and Lavarel is again beyond my capabilities)</p>
  
  <p>I don't mind learning new things, so if VBA or otherwise is the only answer, I'll just learn! However, this seems like a simple function that can be done in excel and that I've just missed something crucial. I prefer to keep the database as simple as possible, it's less likely to break!</p>
  
  <p>I'd really appreciate your help. Thanks!</p>