What is the best way to incorporate a table of years to contain xman a

[handlebars]

Sorry if the above sounds a bit vaugue, I am trying to normalise a database theat tracks client applications and affiliates contributions. I want to take out the repeating information with regards to annual events for the various members and affiliates. Can anyone suggest how the tables could be related. For one I know that i want to be able to report on which events a member has attended or been invited to for each and every year.

Do I create one table of just years that is essentially a lookup table for for an attendence table whcih could be related to the member and affiliates tables for each?

Any help or general direction on the above would be much appreciated.

Thanks in advance

Andrew

 

[dhookom]

It is difficult to suggest anything without it being a WAG since we don't know your current table structure. I would create a table of events with one record per event. Then a table that contains one record per event per person. There might be fields in this table that identify the person, the event, status, etc.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[fkegley]

As Duane says, create one table for client applications, one for affiliates contributions, and one for attendance. the attendance table would be the one that relates one record in client applications to one record in affiliates contributions tables

Frank kegley
fkegley@hotmail.com