Ok, now that I understand the gist of adding a field to my database I was wondering if there is a script out there that someone has that adds a field to the database at the Xth position. Like if I wanted to add a new field between Name and Description.

The reason for this: I want to add fields to my database. I know how to add them at the end using the modified upgrade_beta.pl script. But I don't want to add them at the end, but instead someplace in the middle of the record. I want to view the fields of the record in a certain order, and it will not be intuitive if I have all these unrelated fields at the end of the record. Make sense?

I know this is possible and was wondering if anyone has done it (or can do it easily) before I pull out my "Programming in PERL" book.

Thanks
crisco

[This message has been edited by crisco (edited March 29, 1999).]