Database Design Question

[ychousa]

Hi.
I need to creat a show expense database. The shows are usually held once a year. Currently I have about 150 shows. The form I want to build should display showID, name, year, and all other information. After the form is open, a user can select a year to display all information of that specific year without changing showID and name on the form.

I have a main table with showID and year, and a detail table with year and all other info.

How would I design this database?

Thanks alot in advance!

 

[p27br]

hi

why not start by reading the basics on database design ?
you can find an article here :

http://support.microsoft.com/default.aspx?scid=kb;en-us;164172

I would have a 'SHOW' table and a YEAR table, then you should have a foreign key (year) in your show table. So you have a relationship between the two tables. Can a show occur only once per year ?

 

[willir]

There are a few Tek-Tips to that may help...

thread700-628486