Sequential count inserting

[sethbowers]

When creating a record I need a number inserted in order to count the records that are related to a given master file. I.E. Our bids have multiple rooms, each room needs a serial number. Kitchen, 1, Bathroom, 2 etc. I have tried multiple ways to find the current record count, add one to that, etc... I know it is something simple, i just can't figure it out.!?.

[Genx]

Have a look here see if it helps, if not, please explain a bit more.

[sethbowers]

That is what I needed, thanks much. You saved me many an hour.: