Database Question in Access 2003

SoundTheSurrender

Diamond Member
Mar 13, 2005
3,126
0
0
For my project I am doing a Team Group Table.

The function of this table would be to have a Pilot, and then attendent.

As of now the group leader is it their own table and the workers are in their own table as well.

All information is the same but what makes them different is that Group leaders are salary and workers are wage based.

What I would like to do is create a table that will take one pilot and one attendant and form a group.

What would you suggest the best course of action?

Should I create a group table that has a group number and then apply this to the two tables? (pilot, and attendent)

This will be linked to a schedule table.
 

brandonbull

Diamond Member
May 3, 2005
6,365
1,223
126
I would say the GROUP Table would store 1 record for each member of a group and members of the same group would have the same group name/number.

Group_Number, Person_ID