Retrieve Data From Crosstab Table

[Spidey]

Hi,

I am new to filemaker.  I have created a crosstab table and I like to retrieve data from it in another table.  For example,  in the layout, "RetrieveData",  I like to retrieve the activity name "Apple" in March, I like to get the value "24".  How I should approach it in the relationship.   

Many Thanks.

Kent

CrossTabInputExample.fmp12

[Ocean West]

if your cross tab table is always going only have 12 months you could add a field and it could be calculated  

jan & ¶ & feb & ¶ & mar & ¶ & apr (etc all 12 months.)

Then once your name matches "Apple" via a relationship  just use GetValue ( data ; Month ( dateField  ) )