I have a typed data that I've created that links the table 'Contacts' to the table 'Clubs' via a table called 'ClubContacts' - e.g. there's a relation between 'Contacts' & 'ClubContacts', and a relation between 'Clubs' & 'ClubContacts'

On my form there is a bound grid for the 'Clubs' table and a bound grid for the 'Contacts' table. What I want is for the contents of the 'Contacts' grid to update dependent on the current record in the 'Clubs' grid. I figure there must be a way to get the dataset to drive this behaviour, but I can't work it out.