Re: Howto add/remove columns in Table Editor

[Barry Galbraith]

I wouldn't have thought "users" would be looking at your tables.

You might save all the country names in a table called tblCountry and use the row id as a pointer, and store the pointer in the domicile table. Same with postal codes.
Then a raw view of your domicile table would then be unreadable, but quite readable with an application using a JOIN.

You could use the Query browser to pull the fields you want from multiple tables with JOINs, and present them in the order you desire, then make a View of your SELECT. The table columns themselves can be any order.

But I wouldn't let users use the Query Browser to look at my tables.

Tables are places where you keep your data, they are not for general consumption. Only administrators should be looking at tables.

Good Luck.
Barry.