I need to get all values of Repeating field from calculation fields 
Author Message
 I need to get all values of Repeating field from calculation fields
Is there any way to get all the values from a repeating field on a
calculation field?

With GetRepetition I can only get a specified value, and Last(), wel it
returns the last repetition. Also Last returns the last related field, if
the field is a related field.

The actual thing I want is to get all the values from a related field,
there is a trick involving value lists but it has limitations for the
size of fields I'm working with.

Sent via Deja.com http://www.***.com/
Before you buy.



Sun, 10 Nov 2002 03:00:00 GMT
 I need to get all values of Repeating field from calculation fields

I would suggest dumping the repeating fields for a proper relationship.
Repeating fields are extremely limited.  The section in the on-line help
titled "Defining repeating fields" reads (in part) as follows:

"Note:  If you anticipate having to sort or summarize the information you
plan to enter in a repeating field, it is typically easier to use a related
database and a portal to display the information instead. Repeating fields
cannot be sorted, and the information in a repeating field cannot be
directly summarized."

If you won't take my advice, take FileMaker, Inc.'s...


Quote:
> Is there any way to get all the values from a repeating field on a
> calculation field?

> With GetRepetition I can only get a specified value, and Last(), wel it
> returns the last repetition. Also Last returns the last related field, if
> the field is a related field.

> The actual thing I want is to get all the values from a related field,
> there is a trick involving value lists but it has limitations for the
> size of fields I'm working with.

> Sent via Deja.com http://www.deja.com/
> Before you buy.



Sun, 10 Nov 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Text Field -> Repeating Calculation (Text) Field

2. Can calculation fields be repeating fields?

3. need to align a single text field with a repeating Number field

4. Calculation or Auto Entered Repeating Fields

5. Calculation using repeating fields and relationship

6. Calculations based on Repeating Fields

7. Calculation in repeating field

8. Repeating fields, images, and calculations

9. please help with repeating calculation field - tia!

10. Repeat loop in calculation field

11. Lookup's, Calculations & Repeating Fields

12. repeating field calculation


 
Powered by phpBB® Forum Software