Hello, here is what I have
[TABLE="width: 500"]
<tbody>[TR]
[TD]Case[/TD]
[TD]pk[/TD]
[/TR]
[TR]
[TD]212[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]1212[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]444[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]111[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
Table B
[TABLE="width: 500"]
<tbody>[TR]
[TD]pk[/TD]
[TD]category[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]muffin[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]bagel[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]pizza[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]toast[/TD]
[/TR]
</tbody>[/TABLE]
I created a relationship between them and i know i can go to table A and do related(TableB'category'), the problem is that this creates another table and what I want to do is create a pivot table from A and show this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]case[/TD]
[TD]category[/TD]
[/TR]
[TR]
[TD]212[/TD]
[TD]muffin[/TD]
[/TR]
[TR]
[TD]1212[/TD]
[TD]bagel[/TD]
[/TR]
[TR]
[TD]444[/TD]
[TD]muffin[/TD]
[/TR]
[TR]
[TD]111[/TD]
[TD]pizza[/TD]
[/TR]
</tbody>[/TABLE]
I need to show this table in this format as a pivot table (people want to see the category for each case)
If I just do this with that relationship what I get is something that looks like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]111[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]bagel[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]muffin[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]pizza[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]toast[/TD]
[/TR]
</tbody>[/TABLE]
Its as if the relationship wasn't being recognized, any idea how to do this?
Thanks
[TABLE="width: 500"]
<tbody>[TR]
[TD]Case[/TD]
[TD]pk[/TD]
[/TR]
[TR]
[TD]212[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]1212[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]444[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]111[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
Table B
[TABLE="width: 500"]
<tbody>[TR]
[TD]pk[/TD]
[TD]category[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]muffin[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]bagel[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]pizza[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]toast[/TD]
[/TR]
</tbody>[/TABLE]
I created a relationship between them and i know i can go to table A and do related(TableB'category'), the problem is that this creates another table and what I want to do is create a pivot table from A and show this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]case[/TD]
[TD]category[/TD]
[/TR]
[TR]
[TD]212[/TD]
[TD]muffin[/TD]
[/TR]
[TR]
[TD]1212[/TD]
[TD]bagel[/TD]
[/TR]
[TR]
[TD]444[/TD]
[TD]muffin[/TD]
[/TR]
[TR]
[TD]111[/TD]
[TD]pizza[/TD]
[/TR]
</tbody>[/TABLE]
I need to show this table in this format as a pivot table (people want to see the category for each case)
If I just do this with that relationship what I get is something that looks like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]111[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]bagel[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]muffin[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]pizza[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]toast[/TD]
[/TR]
</tbody>[/TABLE]
Its as if the relationship wasn't being recognized, any idea how to do this?
Thanks