2 Replies Latest reply on Feb 21, 2016 8:09 AM by njudson6

    Lookup Value based on two criteria??

    njudson6

      I've have searched and searched and can't seem to find an answer. So here we go.

       

      I have two tables; "In House Jobs" and "Paper Catalog" with the following fields.

       

      In House Job Table consists of

      Paper Size

      Paper Description

      Cost Per Sheet

       

      Paper Catalog Table consist of

      Paper Size

      Paper Description

      Cost Per Sheet


      They are Related by Paper Size = Paper Size


      When I am in In House Job table I select the paper size from a drop down. Once a size is selected the Paper Description drop down changes based off that size. The lists are being looked up from the paper catalog. Once I select a Paper Description I want the cost per sheet to lookup the correct value. So I am trying to have Cost Per Sheet lookup automatically based off the paper size and paper description.

       

      Thanks in advance!