I am working on a inventory document for my Boy Scout Summer Camp. There are a couple things i am needing to do that i am lost on. First, I am needing the table entries to auto combine with duplicates. For example, i enter leather as one entry and then when i go to enter leather again it will just add the quantity of leather together and delete the duplicate. How can i get this to work? My second problem; Is there a way that i can have a drop down box, that when selected, chooses which table (i.e. - Inventory, Needs, or Wish list Tables) the data will be saved in. Question three is how do i get the table to auto add "N/A" when a field is left blank? Thank you for your assistance!