I had a form that would like you select an employee that you are trying to assign a port to with a combo box. There was a second combo box that would let you select the IT closet port that they would be assigned to. Then you click save and it adds it to the database. Here is the set up.
I have tbl1Employees - Houses all employee information
I have tbl1PortSlots - Houses all the port information in the IT closet.
I have tbl3PortSlotAssignments - has a relationship between the two above tables where it is the middleman and can give you free range to input the employeeID and the portslotID and have it shown when queried.
I want a form to where you can do this instead of manual entry on the table.