Hi,
I have designed a table and saved it. Having done so I find I want to move a field to a new position and insert a new field. Can I do this, if so how?
Thanks,
Jim
Which data base are you connecting to, e.g. HSQLDB, MySQL, …? LO is fairly brain dead at doing this. But because I choose to normally connect to MariaDB (a MySQL clone) databases, I can use HeidiSQL to easily organize the order of my fields. While it’s true that the computer doesn’t care what order they are in, the human is often helped considerably by having them neat and tidy. For example I like to have ID first, Born date next, followed by other things, and often Notes at the end.
Hello,
The position of fields within a table is unimportant. I have not actually done so, but I have seen where this can be done by getting into the depths of the database.
If you truly need to see positioning of the fields using the Base interface, you will have to delete the old & enter the new.
If this answers your question please tick the 
(upper left area of answer). It helps others to know there was an accepted answer.