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

    Dependant Drop Down

    Level 1



      I have 3 tables:






      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