3 Replies Latest reply on Jan 5, 2011 7:03 AM by deansy55

    Dependant Drop Down

      Hi,

       

      I have 3 tables:

       

      ProductTypes

      Products

      Cash

       

      when inserting into the cash table i need to allow the user to select from a drop down the producttype which then pre populates the products drop down with the productID's.

       

      What i need to do next is then when the select the product ID it puts the product ref and description into the a text area in the same form?  any idea how to do this?

       

      the first part i can do with the drop down wizard but not sure how to then get it to carry over into the text area as the drop down wizard creates 2 recordsets?

       

      hope someone can help.

       

      many thanks