Just wondering

I have made a database for our lotto syndicate at work (we only play on the Bonus ball)

I have a table with the date and the lottery draws which I update weekly, I then have to go to the table that has all the names and their numbers 1 to 49 then I add 1 to the winners field. so we can see the history of the winners.

Is there a way of having the table with the numbers automaticaly updated just by entering in the latest numbers in the first table?

if anyone can help me I will show you how to make a database that generates the next winning numbers. lol


thanks

Have a look at update queries. Before you do make an update query though make a select query to show the winning combinations, once you have this working add the feld you want to update and change the query to an update query.

thanx for reply