Beno Posted March 4, 2004 Share Posted March 4, 2004 Hi everybody ! I have troubles with repeating fields. 1. How is it possible to know how many repetitions of a repeating fiels are used ? 2. I would like to insert a value into the Xth repetition of a repeating field. How is that possible ? 3. I also want to know if a specific value is present in the repetitions of a repeating fields. How can I do that ? Thanks a lot !!! Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted March 4, 2004 Share Posted March 4, 2004 Hi Beno InsertRepeats.fp5.zip Link to comment Share on other sites More sharing options...
Beno Posted March 4, 2004 Author Share Posted March 4, 2004 Well, that's what I call a precious help. I haven't tried everything yet, but it seems like my problem is solved. Thanks a lot. These fields are a real pain in the *** ;o) Link to comment Share on other sites More sharing options...
bruceR Posted March 4, 2004 Share Posted March 4, 2004 If you're having all these problems with repeating fields, then the best advice is to ditch them. Filemaker went relational with version 3, and that was quite some time ago. Link to comment Share on other sites More sharing options...
Beno Posted March 9, 2004 Author Share Posted March 9, 2004 I would like some more precisions concerning question 2 ;o) I'd like to insert a value in the Xth repetition of a repeating field, but the other value of that field are not enterred by a lookup. Is there a way to do it without defining a lookup. By the way, I didn't find the Sample section (sorry /) Thanks a lot Version: Developer v6 Platform: Windows XP Link to comment Share on other sites More sharing options...
Beno Posted March 9, 2004 Author Share Posted March 9, 2004 Ok, I found the sample section and the example of Ernst. My problem is that the repeating field is again set by a lookup. Isn't it another way : Version: Developer v6 Platform: Windows XP Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted March 9, 2004 Share Posted March 9, 2004 Well, You may trigger a lookup when needed and still manually fill the field. At wish, as in any other lookup defined field... Link to comment Share on other sites More sharing options...
Beno Posted March 9, 2004 Author Share Posted March 9, 2004 Ok. Even if the value I want to insert depends on the data I entered in the repetitions of the field ? In fact, I enter all the values in the field and then I would like to auto-enter a value at the end of the repetitions, depending on the current values of the repetitions. I'm afraid that a lookup will crush and replace all the values of the field. Tell me if I'm wrong Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted March 10, 2004 Share Posted March 10, 2004 See attached if this demo help Version: v5.x Platform: Mac OS 9 InsertRepX.fp5.zip Link to comment Share on other sites More sharing options...
Beno Posted March 10, 2004 Author Share Posted March 10, 2004 Well, thanks a lot for your time and your help, which were very useful ! I will try to implement this. see you next time ;o Link to comment Share on other sites More sharing options...
the Otter Posted June 10, 2004 Share Posted June 10, 2004 BruceR, While it Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted June 10, 2004 Share Posted June 10, 2004 Hi, You don't give us too much information about the exact data you're dealing with, and why you'd need that many relationships, but...I agree repeating fields are very handy when it comes to reporting and statistics. Link to comment Share on other sites More sharing options...
bruceR Posted June 10, 2004 Share Posted June 10, 2004 As a way of distilling or reporting on data that is already properly normalized, repeats can be extremely useful and I'm quite aware of that. That doesn't seem to be the case here, and most people who ask about repeats haven't mastered the important basic relational concepts. Repeats have become even more versatile in FM7 and that's good if properly understood. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7252 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