Jump to content

Calculated lookups based on dropdown selection


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

Recommended Posts

  • Newbies

Hello,

I'm trying without success to do the following...

I have a portal with a Artist table as context. I have related another ArtLabourItems table in another file to the Artist table.

Then I have a ArtLabourType dropdown field in the portal that defines an automatic value list from the ArtLabourType field in the ArtLabourItems table. This works fine.

There is also a Price field in the portal that is defined as a calulation. When a ArtLabourType is selected from the dropdown I want the Price field to lookup its value via a calulation from the ArtLabourItems table.

Basically I just want to select a value in the dropdown and then have other portal fields automatically filled in.

Right now when I select the "One Hour" option from the dropdown I get a "?" in the portal Price field when using the following calculation for the Price field...

Case(

ArtworkLabourType = "One Hour"; Lookup (ArtworkLabourItems::ArtworkLabourBasePrice);

ArtworkLabourType = "Elaborate";"1000";

"0")

How do I get this to work?

Thom

Link to comment
Share on other sites

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.