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

Relational Valuelist Problem!

May 7, 200718 yr

Hi everyone,

Have this Database working with invoices. I have a membership table that pulls values from a separate Database that holds the item number and description. So I now have a valuelist that pulls all the values from the item DB and shows them as a pop-up list. I want to have the list only show the values that are marked as Active in the item DB.

I had the tables linked through item number, which displayed everything. Then, I tried linking the relationship through a global field = Active to the field in the item DB marked as active or dormant. This change is still pulling everything, so I figure its something wrong with the value list set up. Does anyone have any suggestions?

Thanks!