Can I hide fields that I don't want to be seen ?
Sorry if I have misunderstood the question but it seems quite simple to me - go into Layout mode (Ctrl/Cmd-L), select the fields in question and press the delete key. Is that what you meant or do you need some kind of dynamic delete ability?
Yes, your method works OK. I was just trying to have these "special" fields located to
the far right on my table and have a way to conveniently hide them and unhide them as
needed. Thanks for your help.
Can't get GetNextSerialValue to work as a calculation value for a field.
Try this calculation:
GetNextSerialValue ( Get ( FileName ) ; "the name of your key index field" )
Your method makes sense but I couldn't apply it correctly.
However, I did discover my mistake. For the first argument,
I was giving it the name of the table and not the file. They are
the same except the name of the file has an extra "A" on the
end of it. The file has several tables, but the field that I want
is in the current table, so I didn't have to also give the name of the
table. Also, it has to be in quotes. Thanks for your help.