Multiple 'databases' within one db

[Grimmers]

I have a database that I have been using quite sucessfully for the last few years but now it is time to 'tickle' it up.

The database is a fishing tournament database that basically records anglers, boats and their catch. I would like to, say have a button, that will create a new tournament within the database. To save time keypunching, I would like to keep the list of anglers and boats to draw from as the majority of anglers will have fished a tournament before but maybe from a different boat. Fish caught would have to be new for a new tournament and I need to run some simple reports based on any of the tournaments in the database.

On opening the database, I envisage a list box to historically pick a tournament or open the current tournament, or have a button to create a new tournament.

I am not quite sure on how to approach this and would like some input you guys to help me on my way.

I hope I have explained myself well enough for you to get the jist of what i am trying to do.

Kind Regards,



David

 

[gemma-the-husky]

one way

presumably at the moment the anglersdailycatch table stands at the "top" of the database

so add a contest table, and an anglerstakingpart table, linking contests to anglers. now instead of leaving the dailycatchtable at the "top" as it were, link that table to the contest table - you will need to add a new field to that table to store the contest ref

even dont bother with the anglerstakingpart tasble - think this still works, assuming every angler returns a catch

hope this makes sense