I have a many to many situation (two tables with a join table). I have a form with the primary table (Projects) and a subform (keywords which also includes the join table). When I add a new keyword, using notinlist event for the idkeyword field in the subform (which open the keyword table to add the new keyword) --- the new keyword appears twice in the keyword table and once in the join. Example: I want to add the keyword Banana. I write it in the keyword field in the subform and am taken to a popup form -- I type in Banana and it shows the idkeyword as being 100. I shut that form and Banana appears in my subform, but the idkeyword (of the join) is 101. Open up the keyword table: idkeyword 100 is Banana and idkeyword 101 is Banana. Open up the Join table, 101 is Banana joined to the right idProject What can I do to add the new keyword only once in the keyword table as well as only once in the join?