Søren Dyhr Posted March 2, 2005 Share Posted March 2, 2005 In order to make such as "Each monday" do I use of multilinekeys instead of inner join records, because it's easier to change to "Each Tuesday" if the key is made by a repeating field exploiting Get ( CalculationRepetitionNumber ) for generating each date in the key instead of Ray's recursively defined RangeKey( ) from his template http://www.nightwing.com.au/FileMaker/demos7/demo705.html Now I do not in this case work with the freestored principle as Ray does in his, but instead with an Albert Albert Harum-Alvarez scratchpad to make conflicts show up in either overlapping dates or matches in a returndelimited field of resources. This is a stacked relation two multiline fields matching multiline on the other side ...so it's AND instead of "or" as I just wrote. It's these returndelimited ID for resources being booked, that I seek a faster algorithm than what it is at present, where I first try the entire set of ID's to get a matching related record or more. If a conflict occures do I a bit silly tryout each of the ID's succesively ...but I do only in the mist remember the "Tower of Hanoi" and "Bubble Sort" which is the way it should be speeded up ...if I just could get my mind straightned slighly... So the aim is via a clever algorithm to sort the conflicting ID's to one of the ends of the returndelimited and knowing how many allowed ID's can be booked. You could say that the repeating field key is far fetched as principle but all alterations are utterly fast, instead of loops inside loops to make records for each Monday and say friday in a span of two months. Well it works as it is, but it annoys me to have such a half-witted algorithm!!! --sd Link to comment Share on other sites More sharing options...
This topic is 6596 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