Relational database/ ms chart control

[marek85]

Hi,
I've got some problem with that, I'm quite newbie both with relational databases, and ms chart control. Where's the poin't :

I;ve got 3 Tables in my DB : TICKETS, WEEKLY_TICKETS, TICKETSUSED
TICKETS AND WEEKLY_TICKETS are preaty the same - the have clomuns like name, adres, blabla, and TICKETID
TICKETID is also the only one column in TICKETUSED

what i want to achive - have in datagridview list of all tickets, with detail from TCIKETS and WEEKLYTICKETS, that TICKETID's are in TICKETUSED

i got it already by using in datadapter SELECT WHERE, so i didn't have to use any relation in diagrams ?


how about charting data that i've got now in datagrid ?
I mean how can i get a series to chart from that datagridview, f.e. histogram with names of those tickets owners ?, or their postals ?
do i have to use some diagrams ? od it would be posible just to ply with my new datagrid view ?


I hope i didn't make it more complicated that it is , and hope someone could help me just a bit ..

thanks a lot in advance

[marek85]

I've tried with DataBindCrossTab but it looks like thats not what i was looking for ;/ ...