GlennC Posted April 10, 2004 Share Posted April 10, 2004 I need to have FM perform a scripted lookup in date order, because later records will be dependant on the lookup of earlier records occurring first. The lookuup is based on a self-join relationship. My question: will this be determined by selecting 'date' for sorting records in the relationship definition, or has that got nothing to do with it? Or does the current sort order of the records determine the processing order? Enlightenment gratefully received. FileMaker Version: 6 Platform: Windows XP Link to comment Share on other sites More sharing options...
BobWeaver Posted April 10, 2004 Share Posted April 10, 2004 If there are multiple related records, then the lookup value will come from the first record in the sort order, if the relationship has the sort option selected. If the sort option is not selected, then the value will be taken from the first record found in the unsorted order (ie, the earliest created related record). Link to comment Share on other sites More sharing options...
GlennC Posted April 11, 2004 Author Share Posted April 11, 2004 Thanks Bob. I should have stated my question more clearly. The concern is not with the record where the looked-up value is coming from, but the records that are doing the looking-up. Those records need to do the process in chronolgical order. How can I enusre this? Link to comment Share on other sites More sharing options...
GlennC Posted April 13, 2004 Author Share Posted April 13, 2004 Anyone? Link to comment Share on other sites More sharing options...
Ender Posted April 13, 2004 Share Posted April 13, 2004 You could probably experiment with your Relookup to see what it does. If you want to be sure, you can Sort, then use a Loop with a Set Field to update the fields. Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted April 13, 2004 Share Posted April 13, 2004 Hi, You'd need to move to another calculated key, upon which the lookup would be triggered or not. It's not clear enough what your settings are though, but it may require an extra field, which would be looked up as well and which value (if not empty) would be used as a variable for your conditional lookup. FileMaker Version: 6 Platform: Mac OS 9 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7310 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