List function

[EllenG]

I have a calc field in one table that uses the List function from a related table (matched by date) to list the matching records. Is there a way to limit the records in the List function? I only want to take the first 5 or 6 records from the related List field.

[Peter (duksis3)]

I don't knew all conditions but will use some auto-enter serial when create records with the same date, and add in the relationship condition AutoEnterSerial<=5 , where 5 or 6 is number determine reflected records in the List.

You must define global field or global variable to keep this 5 or 6.

But... sometimes you need to "get out" 5 or 6 from all list (from beginning, middle or end). Here other conditions can be important and I don't knew them.

[Raybaudi]

Is there a way to limit the records in the List function? I only want to take the first 5 or 6 records from the related List field.

LeftValues ( List ( YoutTable::YourField ) ; 5 )

[LaRetta]

Keep in mind that, if you are grabbing the first five list values, it will be the first five depending upon a sort specified at the relationship level. If no sort is specified then it will be the first five created child records (known as natural sort order). :wink2:

[Peter (duksis3)]

Left Words (List,5) must bee correct, I suppose.

[Raybaudi]

A value in a value list can have more than one word.

[EllenG]

LeftValues worked... just what I needed.

Thanks

[Peter (duksis3)]

That's true:)