Sequential Numbering of Related Portal Records

[chikanyc]

Hi I'm working with two different databases. Each record in the database called "Catalog" is of a CD with its information and a portal to another database called "Items". I input tracklistings via the portal in Catalog. Every new portal row generates a new record in Items that records the unique CD number. I would also like the Items record generated by the portal in Catalog to include the track number (what position the song places in the tracklist).

Is there a way to define a field so that it generates a track # if a track is defined/Items record generated?

I know that an option is to to insert a text box of "@@" to generate a number for the portal row, but that @@ information does not get copied to the portal record (in Items). I would like a track number that is permanent and part of the Items record.

Thanks:)

Edited January 4, 2008 by Guest

[Søren Dyhr]

If you can live with the sequence first gets established when the record is committed, could it be done this way:

--sd

test.zip

[chikanyc]

thanks a lot, sd. it worked perfectly!