AnsweredAssumed Answered

Lookup Value based on two criteria??

Question asked by njudson6 on Feb 20, 2016
Latest reply on Feb 21, 2016 by 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!


Outcomes