How to show text from a relationship table
I am setting up my Data Assist Details page and in my database "Product" table I have field entitled "ProductPcolorsID" this field is the reference for the product's colors. The "Pcolors" table has the following two fields that the Product table is referencing: "PcolorsID" and a "PcolorName" field.
On my details page it is showing the "PcolorsID"( i.e., "1") number, however I want show the "PcolorName" (i.e., "red") that it references . How do I accomplish this.
Thanks as always.