1 Reply Latest reply on Jul 31, 2007 10:16 AM by bregent

    Populate Drop Down from DB entries

    Level 7
      Hi there.

      ASP VBScript with Access db.

      I have created a page where people can upload photos to our web with
      Pure ASP Upload.
      Part of the upload is that the person who uploads must add it to a
      category. This category gets populated from the entries people make.
      What happens now, is that even though there is already a Category A, the
      script/add data SB adds another instance of Category A. It so happens
      that there are a few Category A, B & C.

      What must I do to have the add record SB first check if there is a
      Category A, and if not, adds it and if there is one, DO NOT add another?

      I hope I used the correct terms & wording to explain what I want.
      Thank you so much for your help.