I have a form where information on a person is entered (e.g., first name, lastname, dob, etc.)

I want to categorize the people by the type of person that they are on this form (e.g., employee, contractor, agent, salesman, etc.)

There are around a dozen categories of people coming from a lookuptable, tluPersonType.

The tricky part is that sometimes a person is a member of multiple categories (e.g., he might be an employee and a salesman) so I need to determine how to on one form let a person select multiple person categories.

The tables involved are:

tblPeople
PersonID - PK
PersonTypeID
SalutationTypeID
FirstName
MiddleName
LastName
SSN
Password

tluPersonType
PersonTypeID - PK
PersonType

tjxPersonPersonType
PersonPersonTypeID - PK
PersonTypeID - FK
PersonID - FK

At present, I have a subform on the main form and have set the ctrl src of the subform to tjxPersonPersonType.

I suspect each of the checkboxes needs to be with a control source of PersonPersonTypeID and then have a default value set to something like 1,2,3,...number for each PersonTypeID.

However, I can't quite get it to work. Can anyone see what I am doing wrong or offer any suggestions?

Any advice will be greatly appreciated.

It seems to me that this is a deign issue. The person type should have mutually exclusive catergories.

For example, it goes without saying that a salesperson is also an employee, otherwise they couldn't be one of your salespeople.

Perhaps having a person type category, and then a departmental look up will clear this up.

Anyway, if a person is an employee, you can show the department combo box and let the user select the Sales department, or something like that.

HTH

mmcdonal

Or s "design issue" =)

mmcdonal