how to insert row between two existing rows

[rg]

hi all,

OO2.0RC1, winxp non-english windows

i use tables | create table in design view created a simple table include

primary key
first name
last name
note

if i want to add a row called 'mobile' between 'last name' and 'note' in the table, how can i do it?
insert row seems only append mobile after note...


thanks
regards,
rg

[DrewJensen]

rg,

You can't. Not using the GUI tool anyway. Actually this is a function of the way SQL would handle this. Once a table is made you can DROP a column and you can ALTER a table with ADD column. The ADDed column is always appended to the end of the table.

This isn't really that much of a problem. Say I have your new table

primary key
first name
last name
note
mobile

I want to vew it in a different order. I can just create a query that uses this one table, or a view. And in the query I can rearrange the columns as I like.

HTH

Drew Jensen
_________________
Blog - http://baseanswers.spaces.live.com/

[rg]

Hi Drew,

thanks for your reply

so, is that mean to put 'mobile' after 'note', use either 'insert row' or directly type the field 'mobile' below 'note' will be the same

if the above assumption is correct, the 'insert row' seems redundant...

regards,
rg

[DrewJensen]

yes it does doesn't it.

Drew
_________________
Blog - http://baseanswers.spaces.live.com/