Is there a way to update the previous record in same table?

Run an Automation triggered on new record creation that applies to max (max [rid]) -1 ?

Is max[rid] a valid function?  I'm trying to use it in a formula url field and it's not working.  Does it only work in Automations?

You will need to set up a dummy table called like Max Record ID of the XYZ table with one and only 1 record in it.  It will be Record 1.

Then make a relationship to your details table and make the reference field on the right side be a formula field which calculates to 1. The formula will be, well , 1.

Then do a summary maximum of the [Record ID#] field and look that up down to the details table.

Whew!  Thank you again!

So, that'll tell you how many records are in the table, but it won't give you the actual highest Record ID#, will it?  If records have been deleted along the way those two numbers won't line up.  Is that right?

:) when you do a summary field, you can select a field to Summarize and so you will select [Record ID#]  and then choose a type of summary of  "Maximum

Bingo!  Thank you!