Creating a Chart in Home Layout

[scchoi]

hey guys,

I'm trying to create a homepage that display a chart of my records. for example let's say i got a record full of basketball cards. basketball cards have their own entire different table with the fields basketball cards name, year, price, etc. and then i have another table that lists the basketball cards according to their team. in other words, it's a table that has perhaps, a list of entire team and an ID for each team.

what i did was i have a relationship BasketballCards to BasketballCards_Teams

If I want to create a chart in my home page which has a designated table of its own (a home table) that shows how many cards there are per teams, how would i go about in doing so? Or in other words:

I have my Data from X-axis (the teams) and the Data from Y-axis (the cards) and I want to show how many cards there are per teams in my collection. I got the two data, but how do I create a script that'll link them together and then put that script within my chart? Any examples? or links to examples that I can work from?

Thanks FMForum!,

scchoi