# Lookup Value Based on Two Criteria

This topic is 2321 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

• Newbies

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.

##### Share on other sites

If you want to look up the price based on two criteria then define the relationship on two criteria (two fields).

##### Share on other sites

• Newbies
9 hours ago, BruceR said:

If you want to look up the price based on two criteria then define the relationship on two criteria (two fields).

That works, but when I make the two relationships, my conditional value lists don't work. I have to show all in each field. Is there a way to keep that conditional value list intact and still have it lookup the value?

I got! I understood what you meant. I needed two Relationships from the Paper Catalog. One for the conditional lists and the other for pulling the data.

##### Share on other sites

This topic is 2321 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account

• ### Similar Content

• #### Simple Calculation Question: Total Sum of hours per CLIENT

By Sharifa,

• 4 replies
• 56 views
• #### Problems with Reverse Calculation

By Mafia2020,

• 4 replies
• 276 views
• #### Display Related Field In Subsummary Part

By Jay86,

• 3 replies
• 1,854 views
• #### How to generate different Portal line numbers for different parent record

By Guy_Smith,

• 4 replies
• 1,754 views
• #### Extract values from calculated list

By Rich,

• 3 replies
• 471 views
×
×
• Create New...