I am looking for a solution to a problem:

Start-------Add-------Finish

1 1 2
4 2 6
6 -1 5


My question is how do I get the record from finish to appear in the
start column below every other record aside from the first?

Thanks

"MrCedars" <dlukic (AT) gmail (DOT) com> schreef in bericht
news:1182217829.582963.320940 (AT) u2g2000hsc (DOT) googlegroups.com...

you don't state version. But with 8.5 adv you can replace the ctrl-N for a
new record with a script that is performed instead
this creates the record and uses the goto field <fieldname> script step to
end in the fierld you desire.

Otherwise ctrl-N and a simple TAB wil do the job

keep well, ursus

Hi Ursus,

Sorry about that I do have 8.5 Adv.

I have a cross-tab layout, so when I go to Preview I have this section
as Sub-summary when sorted by DATE.

The fields are all Calcs, what I did do to accomplish this was use the
" GetNthRecord ( fieldName ; recordNumber ) ".

So I have " GetNthRecord(Aging_Line;Get(Record Number)-1) ". The
problem is that this works fine on the Parent related table, but as
soon as I take that field and put it on my layout, all I get is
blanks.

Thanks

Dejan

On Jun 19, 4:20 am, "Ursus" <ursus.k... (AT) wanadoo (DOT) nl> wrote:

"MrCedars" <dlukic (AT) gmail (DOT) com> schreef in bericht
news:1182255173.646522.32650 (AT) d30g2000prg (DOT) googlegroups.com...
First the layout has to be referenced to the correct table.
Second when moving a calculated field across tables you have to include the
tablename into the calc.
Resulting in something like
GetNthRecord(Related_table::Aging_Line;Get(Record Number)-1)
The -1 will then display only one previous related value.

Is that any good?

Keep well, Ursus