Jump to content

View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

Condtional value list with Lookup data

Followers

May 13, 200619 yr

Newbies

I wonder if someone can give me some hint on solving the following problem:

For simplicity, I use the following simple scheme. I have an item table with several categories of products, product names of each category, product ID and cost (see Item layout); and a customer layout where I use the conditional value list technique to isolate one category of related items and then choose the correct item from the isolated category. I use the Lookup field option for product ID and cost. Somehow, each time I choose the proper item in a category, only the product ID and cost for the first item of the isolated category is shown. The product ID & cost fields would not show the proper values if I choose 2nd or 3rd item of the isolated category. The bottom part of the customer layout shows the items in the isolated category (see the enclosed zip file)

Lookup.zip