Newbie Q: on structure

[Sonia]

Hi,

This may sound stupid but I would like to create a table to hold some
playing lottery numbers and I'm not sure the type of structure should I use.
The lottery numbers can be in columns of 5 or 6, depending of the type and
(to complicate it even more) can have some bonus numbers associate with
them. I thought of the following columns names but I'm not sure.



Play_ID: Auto number

TodayDate: DateTime

PlayDate: DateTime

PlayType_ID: Number (associated with a type of play table)

ClnN1: Number First number

....

ClnN6: Number Last number

ClnB1: Number Bonus Number 1





What do you think?



TIA

Sonia

 

[Guest]

You could try this: Have a table that just holds the unique identity of the
lottery ticket. Then another table will hold the column information, with
that table referring back to the ticket table.

tbl_Ticket
TicketID (PK) (autonumber)
TicketInfo (whatever you need to uniquely identify this, such as dates,
serial numbers, etc.)

tbl_Columns
ColumnID (PK) (autonumber)
TicketID (this is what ties the information in this table back to your
ticket table)
ColumnDesignation (such as 1, 2, Bonus)
ColumnInfo (this is what is in that column, designated by ColumnDesignation)