Append query using two unrelated tables

[maggiemago3]

I have a database with a "Category_Name" Table and an "Employee" table.



I need the capability to assign Category Names to Employees and append them into 1 separate table. Each employee has to have the capability to appear in more then one category, thus appearing in the final table several times.

I have a form where the end user can select a "Category_Name" using a combo box. Beneath the combo box I have a sub form which lists the employees, where the end user can filter to the employees they wish, using any of the available employee info fields (i.e. use the filter to select 1 employee based on name, or use a filter to select several employees based on location).

I am looking to create code that will take the select "Category_Name" from the combo box and all employees that are showing in the filter in the subform and append the category name and employee id to a new table.

I'm a novice so please don't ask why I'd be using vba if there is a more appropriate alternative please just suggest it. The employee information comes from spreadsheets from outside sources that are imported and merged into a master table in this database. this is a second step to an existing process. my constant that cannot be changes is the employee info table. the category name table is one in which i've designed an end user form, where they can create their own category names which would ultimately be used to assign categories to employees as described in my wish list above.

as stated, I'm a super novice and need all the help I can get.

[June7]

This is many-to-many relationships. Requires a junction table to relate entities. The junction table will have at least two fields - EmpID, CatID - as foreign keys.

Use a form/subform for data entry. Options:

1. main form bound to table Category_Name and subform bound to junction table, combobox in subform to select employee

2. main form bound to table Employee and subform bound to junction table, combobox in subform to select category