I have a help desk application that I am working on developing that has a main table which contains all the information about each ticket, this main table refers to another table called Faculty(and others). This faculty table contains the ID, name, email address of the staff.....

My problem is that when a new ticket is created, and you select the name you want out of the drop down box I have on the main ticket form, it keeps adding the names to the Faculty table.....not just selecting them from a list like I want.

Yes the ticket table is maintaining all of the information as well.

How is it "referring" to the other table. Assuming this is a bound form, you should have a combo bound to the FacultyID field in the main table. If you want to display more info about Faculty member on the form, then use a subform bound to the Faculty table.

HTH

It is a bound combo box....

Its not that I want more info.....I want to stop the names being re-added to my faculty form. My thought is somehow trying to lock the table from being added to.

If I am creating a "new ticket" I want to just select "Joe Johnson" from that combo box and not have it add "Joe Johnson" to the faculty table again once I do.

Assuming that the Main form is bound to the Main table and not a query that joins to the faculty table, it shouldn't be doing that. If it is there has to be some code or something that is causing it. if you can't find it, can you post a copy of the database so we can look.

HTH