For example, I have two tables. Employees and Products.
Inside Employees I have the fields: emp_ID, emp_fname, emp_lname, emp_products Inside Products I have the fields: pro_ID, pro_name, pro_warehouse, pro_employees
Any employee can sell any product. I want to track which employees sell which products, and which products are sold by which employee.
If I do a lookup wizard in Employees: emp_products and allow multiple selections, and the same thing in Products: pro_employees...then in the Employee: emp_products field I select "Dodge Ram" and "Jeep Rubicon" I want that employee added to the respective Product record in Products: pro_employees.
Is this even possible, and if so...how do I go about this? I'm pretty new and I'm having a hard time searching the right words/phrases for this without coming up with relationship support.