List view look

[The Big Bear]

Hi all

I think this has been ask before but I cannot find it.

When there are several records for the same spool number, I would like to display the spool number once until the next spool number and display this number only once until the next spool number appears.

The example does not display well once submitted.

Example

spoolnumber weld number welder id

sp1 1 K

sp1 2 R

sp1 3 A

sp2 1 C

sp2 2 K

sp2 3 A

would like the list view to resemble this:

spool number weld number welder id

sp1 1 K

2 r

3 A

sp2 1 C

2 K

3 A

thanks in advance

Lionel

Edited January 20, 2008 by Guest

[comment]

Try an unstored calculation field =

Case ( SpoolNumber ≠ GetNthRecord ( SpoolNumber ; Get ( RecordNumber ) - 1 ) ; SpoolNumber )

[The Big Bear]

Comment

Thanks for the information

Lionel

[The Big Bear]

Michael

You are a bloody genius. thanks so much for the help.