Help With Table Design

[Guest]

Hello All

I need suggestions on table design

I have several recruiters that will need to enter applicants
There are several (14) types of applicants
Each type has related forms that need to be included in the application packet
There are anywhere from 10 to 30 forms that need to be included in the packet, and there are almost no common forms
I need to be able to track which recruiter added which form to which packet on which day and time

I have no problem with the recruiter and applicant tables, and I found several VBA modules that will tell m
who made the changes to what

The problem I have is relating the forms to the applicants. Do I make a table for each applicant type fille
with the required forms? I'm not quite sure how to handle this. Any Ideas

Thanks
Mike

 

[tina]

the key here is "*almost* no common forms". you're describing a many-to-many
relationship. one applicant type can have many forms, and one form *can* go
to many applicant types (even if most only go to one). in Access you express
a many-to-many relationship with a linking table, as

tblApplicantTypes
ATypeID (primary key)
ATypeName
etc, etc.

tblForms
FormID (primary key)
FormName
etc, etc.

tblAppTypeForms
ATFormID (primary key)
ATypeID (foreign key from tblApplicantTypes)
FormID (foreign key from tblForms)

you can also leave the ATFormID field out of the third table, and use both
remaining fields as a combination primary key. if a given applicant type has
12 forms for instance, then you will enter 12 records for that applicant
type, one for each form.

hth

Hello All,

I need suggestions on table design.

I have several recruiters that will need to enter applicants.
There are several (14) types of applicants.
Each type has related forms that need to be included in the application packet.
There are anywhere from 10 to 30 forms that need to be included in the

packet, and there are almost no common forms.

I need to be able to track which recruiter added which form to which packet on which day and time.

I have no problem with the recruiter and applicant tables, and I found

several VBA modules that will tell me

who made the changes to what.

The problem I have is relating the forms to the applicants. Do I make a

table for each applicant type filled

 

[Guest]

Thanks Tina