Lookup values in search grid results

[den1s]

Hi,

Im not sure how to go about this.

I have a grid based on a table that contains a series of ID numbers.

ID_No
001
002
223
983

When i view this grid, i want to automatically lookup the values of the ID numbers above and display only the names which is contained in another table.

tbl_names
001 Denis
002 Jo
223 Harry
983 Louis

Therefore rather than my grid displaying just a list of ID's, it will display a list of names.

What is the best way to achieve this without having to store the name within the grid table?

Denis

[den1s]

Solved!

I placed a lookup in the calculated field of my grid.

txt    = lookup("[PathAlias.ADB_path]\tbl_ci_project_details","project_id="+quote(Project_id),"Project_Name")