Form / Subform as Datasheet representing 3 tables.

[Ross Colton]

Hello All,
I have 3 tables that need an easy to use front end:

tblHardwareTypesSubTypes
PK | TypeSubTypeID
FK | TypeID
FK | SubTypeID

tblHardwareTypes
PK | TypeID
| Type

Example in the "Type" field: Laptop, PC, Printer, Copier, Network, Telecom,
etc.

tblHardwareSubTypes
PK | SubTypeID
| SubType

Example in the "SubType" field: CD-ROM, CD-RW, DVD-ROM, Black Toner, Yellow
Toner, etc.

The whole purpose of tblHardwareTypesSubTypes is to match all the
subtypes with each type. I did it this way to help reduce redundant data,
but I'm having a difficult time trying to create a form that makes it easy
to match the two up. What I'd like to do is have a Combo Box that sets what
the "Type" is, and then a subform - datasheet where you can select all the
applicable sub-types. The problem is, I can't figure out how to do this!
I've tried to have the main form bound to tblHardwareTypesSubTypes and
have the Combo Box bound to TypeID, but then I can't create a subform that
is bound to the tblHardwareTypesSubTypes.SubTypeID, because that just
creates a new record for each SubType selected without recording the TypeID
in the Combo Box on the main form.

Thanks for any help or advice,
Ross Colton