Linking Tables

[Brian T]

I am setting up a database that will track the awards that personnel are
awarded. The relationships will be many to many I think? I want to see how
many awards each person has. The awards table will have approximately 140
awards. Another twist is that some of the awards are based upon time in
serive. Can these be calculated automatically if the time in service is
known for each person?

 

[KARL DEWEY]

You need a table that just contains employee information and has a primary
key field, preferable an autonumber field.
Next a table of awards with a primary key field.
Third, have a junction table that has the many side of a one-to-many
relationship from the employee table and from the award table. In the
junction table have the employee and award foreign fields.
Use form/subform to enter or view the data. If entering awards for
employee have employee in the main form and the junction table in the subform
with combox to select the awards available.
You can have a second subform to service time award eligibility.