We require a table (MS Access) to be updated the data derived from a text column in the table'Directory'. It is a heirarchy, and we have filled out the first 14 rows to illustrate.
From the 'temp' column
1. Copy the number code to the code column
2. Add the parent level (from directory_id)
3. Add the level
4. Copy the description from the 'temp' column
hieee..i can complete this task in few hours but..can you please let me know..how "level" and "parent_id" has been calculated in your file...???....Regards, Raj