Ive searched everywhere but cannot seem to find out how to find the row position/index in a data table, using a value from another table.

For example, I use the row position from Linkingtable1 to get my value for CustomerID, but i want to use the CustomerID to search the CustomerTable for its row position, in order to show the Customers Name in a text box, As currently when loading the textbox shows the customerID. I understand the code to get the names from the rows in the datatable, its just finding the row position of the customerID.

Bit of a dodgy explanation, but hope you kinda understand

Thanks!