Hi,
This could be a simple answer, but I can't for the life of me find out how to do it - here goes:
I have a Product file and a related Category file. I'm listing the product info. in a Table control (nothing too fancy there), except the value that relates across to the Category file is numeric (foreign key), but I want to display the Description of the Category file and not the numeric value held on the Product file - how is this done?
I've managed to get the Table control to display the Category Description by changing the Category column to type Combo box but it looks strange having a combo box as the table is read only. If I set the Category column back to type Text, I can't link across to the Category table and the Content tab is disabled.
Am I missing something or is this just not possible without using a Combo box?
I hope you understand my problem... thanks in advance...