Select results table dependent on type

[David Ardley]

Hi - have a simple race results tracker. An event could be a cycle race, triathlon or other. The results collected would differ depending on race type.

I have created a results table for each event type, with a single table to record the results for the event.

Can you recommend how I set this up so that depending on the event type, the correct results table is accessed. I only want to present the correct results table.