merkaba22 Posted February 2, 2005 Share Posted February 2, 2005 File one: Record number field Process field Category field File two: Record number field Category field Portal containing Process field. If File one, Record number=::File two, record number for the portal and the Process field within the portal then this Process field returns all Process entries of File one for a particular Record number, regardless of category. What relationship(s) are needed to get the portal to only return only the Process entries of File one by only one particular category for a particular Record number without the category field being present on either the general layout or the portal of File two? Link to comment Share on other sites More sharing options...
TougToug Posted February 2, 2005 Share Posted February 2, 2005 I think you need both "record number field" and "category field" in your relationship. Might be wrong, tell me if it helps or try clarify a bit Link to comment Share on other sites More sharing options...
merkaba22 Posted February 2, 2005 Author Share Posted February 2, 2005 well I figured as much but haven't seen it work yet. I suspecct that I need to create a constant for the value of the category -- but I get lost on this -- I'm a newbie. Thanks:) Link to comment Share on other sites More sharing options...
TougToug Posted February 2, 2005 Share Posted February 2, 2005 maybe try with "record number" as exact match (=) and "category" as show all records (x) double click on the relationship to change it Link to comment Share on other sites More sharing options...
merkaba22 Posted February 2, 2005 Author Share Posted February 2, 2005 Thanks again! I tried your relationship suggestion for the portal and the field inthe portal and combinations with record number=::record number -- not there yet .... There are several Processes and several categories. When I create a relationship Record number =: Record number and the process field in the Portal is the same it returns all Processes for th Record number (not limited by category). What I need is a way to limit the return to one of several categories -- either a constant value equal to the specific category or some other relationship (and I have tried just about every combination between category, process and record number I can thinnk of ..... Still stuck. Link to comment Share on other sites More sharing options...
-Queue- Posted February 2, 2005 Share Posted February 2, 2005 Multi-criteria relationships in pre-FM 7 versions require concatenated key calculation fields, such as, Category & "_" & RecordNumber. Link to comment Share on other sites More sharing options...
sbg2 Posted February 2, 2005 Share Posted February 2, 2005 I'm assuming FM6 can not do multi-condition relationships? I was able to get the results I think you want by doing the following in FM4 (I would upload the file but I'm working on Windows OS) Try creating a calculation in both files, for example: RnC = Record & "-" & Category calculation result is Text then base the relationship on the Calculation field so it will only show processes where the Record Number & the Category both match. Link to comment Share on other sites More sharing options...
merkaba22 Posted February 2, 2005 Author Share Posted February 2, 2005 That was amazing -- it worked right off the bat!!! Thanks a gazillion! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6629 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