jdraw,
I came to the same conclusion after running a few tests. Normally, in the actual database at work it's all done through the use of forms. Members get populated automatically to tblRoster during an import function from excel, after that personnel are assigned to positions if required...