general design question

[steve]

For each project in tblProjects, the user can select a detailer (a detailer
is someone who draws in CAD) from frmProjects. The combobox cboDetailer is
filled from tblSubContractors, which lists the people we sub detailing out
to. The problem is that we also detail in house, so I need to have some
names from tblEmployees as an option.

Do I need two different comboboxes? I'm not sure the best way to handle this.

Thank you,
Steve

 

[Daniel]

You could create a union query between the 2 tables.

Or

Why not have 1 table with the detaillers with a second field 'Type' to
distinguish between in-house and sub-contractor?