is there any way to have a serial # subtract 1 increment if a record is deleted

exp. (0001, 0002, 0003) say 0003 is deleted, next record is normally 0004, can i make it 0003 without going into define fields?

can i print in layout mode and have the field names appear in each field.

thanks for any help you might offer, and sorry if the questions aren't clear

You could set the auto-enter to Max(Serial Number) + 1. This will only work if the user deleted the last record: it won't go back and find missing numbers.

RE: can i print in layout mode and have the field names appear in each field

Yes you can. If you are seeing actual data from the fields. You will need to go to view>Show and unselect sample data.

Michael

Huh?

-bd

Remove foot from mouth, slap self in forehead. I did not realize until I printed a document that will not work. So anyway. Is it possible? I'm curious now.

Sorry for the misleading advice or lack thereof.

Michael

Don't feel bad AudioFreak. For a long time, I thought you could do that, and I told someone the same thing when they asked.

thank you very much folks

this forum rocks

I'm still looking through my older versions to see which one it was that I [color:"red"] was able to do this in.

So far I'm back to FileMaker 4 by Nashoba without any luck. ;(

Lee