Linked tables returning to many values for each record

RickSchultz

New Member
Joined
Sep 12, 2008
Messages
19
Hi! I've created my first PowerPivot workbook. I created 11 tables from a single MySQL database, and linked them based on primary/foreign key pairs.

I created a Pivot Table from the results, and dragged two columns into the row section; one from the "main" data table, and the other from a linked table.

The relationship between the two tables is one-many (from the linked table, basically a lookup table, to the main table). For each primary key in the main table, I should see one value from the linked table.

Instead, for each primary key on the main table, the Pivot Table returned ALL the values in the lookup table; it was as if there was no specified link.

Excel 2010
A
1Row Labels
227
3Brent Leung
4Briana McIvor
5Chester Grant
6Christopher Lacroix
7Dean Ara
8Delete Me
9Doneen Swart
10Elaine McKay
11Gosia Kamela
12Greg Crompton
13hello mister2
14Jay Brown
15Jonny Producer
16Karen Wrafter
17Kristin MacCary
18Nik Green
19Producer Producer
20Research Intern
21Reuben Bradley
22Rick Mattar
23Rob McKee
24Shaun Richards
25Stephanie Barr
26Steve Wyatt
27
Sheet1
Cell Formulas
RangeFormula
A1Row Labels
A227
A3Brent Leung
A4Briana McIvor
A5Chester Grant
A6Christopher Lacroix


Clearly, I've done something wrong with my linking. I've reviewed a few sites to look at normal linking practices, and as far as I can see, I've not done anything wrong. Can someone help me see what I've missed?

Thanks very much!
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,698
Messages
5,855,230
Members
431,713
Latest member
DaveMy1978

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top