Update query From a Concatinated Query. (1 Viewer)

[w8ingforyou]

Hey Guys.

i have a query with 5*left() trim data columns which is generating a set of words which i have concatenated to form a KEY word, which i want to use as a Unique Key.

when i try to update a Id From Main table and this query it is not taking it. i mean unique filed is generated but not updating.

how do we go ahead?

a pointer would help a long.
Regards
Saketh
W8ingforyou.

 

[boerbende]

Do you try to change a unique ID field in a table with your own generated field? This is not possible
Add a second column for your own generated key and store your key there

Hope I undestood your problemdescription right.

Ben