Table Structure

[Dona]

What's the best way to setup this db?

I have the following information:

Company
Company ID
Program A
Program B
Program C
Program D
2000
2001
2002
2003
2004
2005
The years indicate the year the Program participated in the company. For example, Program A participated in Company Z from 2000 to 2005, Program D participanted in Company Z from 2001 to 2002.

Should I have a table with the Companies and Program A and the years from 2000 to 2005
and a table for the Companies and Program B and the years, etc? I was going to add a yes/no field for each program, too. There must be a simplier way.

I want to be able to query participation of workers in any of the programs.

What is the best way to set this up?

Thanks.

 

[Dona]

what is a junction table? what does fld stand for? field? I'm having trouble with tbl CompanyProgram. Please see my sample