Steve Jensen Posted January 18, 2005 Share Posted January 18, 2005 This is strange... I've set up a simple database with two tables... one holding a list of all possible entities (ValueTable), and another that uses those entities (MainDB). I have a value list that pulls data from the ValueTable table. Now, I have a need to restrict that list to some smaller amount... let's say that it's based on the value of a field that can be either "1" (include it) or "0" (don't include it). To do this, I set up a relationship that connects the MainDB to the ValueTable based on matching that boolean field with a calculated "1" in the MainDB. I know set up a value list based on that relationship. No go. I get all the values. I created a portal to show all the related fields, and it is correct. i don't get it. I am not explaining this well, so I've attached a demo. What am I doing wrong? Thanks! ValueListProblem.fp7.zip Link to comment Share on other sites More sharing options...
This topic is 6647 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
Already have an account? Sign in here.Sign In Now