My db has a lookup field on the Orders Table that finds the ProductID, ProductName and ProductPrice of the records in my Products Table. The field that holds this queery is named Product. Product is bound to column 2 in the db, which will give me the ProductName in my app when I fill my dataset and view it in my datatable.
My question is, is there a way to view the other columns in that lookup query? I want to get the price for said product to populate in my app, in the txtprice field. What is the easiest way to do this?
Below is a look at my table structure:
My question is, is there a way to view the other columns in that lookup query? I want to get the price for said product to populate in my app, in the txtprice field. What is the easiest way to do this?
Below is a look at my table structure: