MEG Posted February 28, 2005 Share Posted February 28, 2005 I am using Filemaker 7 and I need to create a conditional value list and honestly would like to scream because I can't get it to work. I have 2 tables Entry and Products. In the products table I have the fields part number and workcenter. I need to display in the Entry table a product value list based on the workcenter field. Example: Operator is in Entry table she chooses Workcenter(WC) 64 I need only the part numbers for WC 64 to display. I have created a self join relationship with the Products table with WC being the match field (products2). Where do I go from here??? I have chosen the part number field from the Products2 starting with Products and chose only relational values and I get <<no values defined>> . I have also chose part number from Products starting with Products2 and I get the same result. I believe that I am in for a lot of frustration - I created a large detailed database for our company in fp5 and I am trying to convert to fp7 and I am a little nervous considering I can't even get a conditional value list to work. Link to comment Share on other sites More sharing options...
-Queue- Posted February 28, 2005 Share Posted February 28, 2005 You don't need a self-join relationship here. You need a relationship from Entry::workcenter to Products::workcenter. Then create a value list of newrelationship::partnumber, 'starting from' the Entry table. When a particular workcenter is selected in Entry, the value list will display its related Product partnumber values. Link to comment Share on other sites More sharing options...
MEG Posted February 28, 2005 Author Share Posted February 28, 2005 Thank you, it worked. Link to comment Share on other sites More sharing options...
guy tanguay Posted March 11, 2005 Share Posted March 11, 2005 Hi , I'm having the same problem , but i don't understand what you just explained ... How can you create a " relationship from Entry::workcenter to Products::workcenter" in the graph ? thx for precisions guy Link to comment Share on other sites More sharing options...
guy tanguay Posted March 11, 2005 Share Posted March 11, 2005 Hi , I'm having the same problem , but i don't understand what you just explained ... How can you create a " relationship from Entry::workcenter to Products::workcenter" in the graph ? thx for precisions guy Link to comment Share on other sites More sharing options...
guy tanguay Posted March 11, 2005 Share Posted March 11, 2005 Hi , I'm having the same problem , but i don't understand what you just explained ... How can you create a " relationship from Entry::workcenter to Products::workcenter" in the graph ? thx for precisions guy Link to comment Share on other sites More sharing options...
-Queue- Posted March 11, 2005 Share Posted March 11, 2005 Make a new relationship, select workcenter from the Entry table and workcenter from the Products table as the matching fields. Your table and field names will vary, of course. Link to comment Share on other sites More sharing options...
-Queue- Posted March 11, 2005 Share Posted March 11, 2005 Make a new relationship, select workcenter from the Entry table and workcenter from the Products table as the matching fields. Your table and field names will vary, of course. Link to comment Share on other sites More sharing options...
-Queue- Posted March 11, 2005 Share Posted March 11, 2005 Make a new relationship, select workcenter from the Entry table and workcenter from the Products table as the matching fields. Your table and field names will vary, of course. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6984 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 accountSign in
Already have an account? Sign in here.
Sign In Now