Relational Valuelist Problem!

[Brett W]

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!