Merging fields into an empty colum dpending on a grouping number and parent/child type.
The best way to explain it is through the table below where the final outcome is what appears in the spare colum.
I can do this over about 6 or 7 different sql commands but when I seem to do it in one go it fails. Can anyone help?
The structure of spare is [fname (of parent in that group) & ' ' & lname (of parent in that group) 'group : ' & fname & lname]
The table has about 50,000 records so needs to be efficient.
fname lname company group type spare
aaa zzz 111 0001 parent aaa zzz group
bbb yyy 222 0001 child aaa zzz group : bbb yyy
ccc xxx 333 0001 child aaa zzz group : ccc xxx
ddd www 444 0002 parent ddd www group
eee vvv 555 0002 child ddd www group : eee vvv
fff uuu 666 0002 child ddd www group : fff uuu