Trouble with repeating fields

[Beno]

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 !!!

[Ugo DI LUCA]

Hi Beno

InsertRepeats.fp5.zip

[Beno]

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)

[bruceR]

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.

[Beno]

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

[Beno]

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

[Ugo DI LUCA]

Well,

You may trigger a lookup when needed and still manually fill the field.

At wish, as in any other lookup defined field...

[Beno]

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

[Ugo DI LUCA]

See attached if this demo help

Version: v5.x

Platform: Mac OS 9

InsertRepX.fp5.zip

[Beno]

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

[the Otter]

BruceR,

While it

[Ugo DI LUCA]

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.

[bruceR]

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.