Relationed serial index number

[Ben Ball]

I have two different tables. T1 & T2.

T1 has an indexing unique serial number

(record Id).

I have a field in T2 which i need to automatically index based on the T1 record ID

so every record I create in T1 the records created in T2 will be sequential starting from 1 each time... not ussing the @@ command... I need it to be in a field... is this possible?

[Ocean West]

How are you creating the children records via a portal or thru a script?

if you are doing it though a portal set the field in T2 to auto enter Get (PortalRowNumber)

if you are scripting it then set a variable to Count(T2::recordid) +1

go to other table create a record and set the field to the contents of the variable.

however should you delete a child record it will not re-sequence the number and you could

potentially have duplicates.