updating columns

[hwagner]

I would like to know if there is a way to update one column from another column in the same table. I want the autonumber field to also be in another column in the same table without making the new column an autonumber feild. Is this possible?

thank you

 

[ItIsHardToProgram]

What would be the purpose?

 

[hwagner]

i have found that if its an autonumber field i cant use it on my form as a look up feild. So if i could get it to put the same value in a seperate column then i can use that column as my look up column.

 

[PHV]

if its an autonumber field i cant use it on my form as a look up feild
???

 

[hwagner]

an autonumber feild can not be edited. so if i keep it as it is they can scrol to get the information they were looking for but they cant type in the field. i want them to be able to type in the field when they are trying to look something up. and i want to be able to do this with out making another input feild on the form.

 

[PHV]

For me, a combo used as a navigation tool shouldn't be bound !

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lespaul]

why would you want to change the autonumber anyway?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[ItIsHardToProgram]

You can look in an autonumber field various ways, first has phv mentioned, having an unbound combobox linked to that autonumber field, 2nd with Dlookup... and many other twisted ways, Sql Query, etc.....

 

[hwagner]

thank you very much i used a text box that was unbound and it works just like i wanted it to.

thanks again