results pages
I have run the data assist wizard and have created a set of pages based on a single table and I have added menu items to record foreign keys of code tables in the update and insert pages.
But I must be missing the obvious because I cannot see how to change the results page to return a text value from my code table instead of the FK storded in the data base.
using the wizard the following SQL is generated
SELECT IP_SNAPSHOT_TABLE.ID,
IP_SNAPSHOT_TABLE.SSI_TABLE_NAME,
IP_SNAPSHOT_TABLE.SSI_SS_DESTINATION
FROM IP_SNAPSHOT_TABLE
However I want to return the text description from the code table not the FK
I have tried updating the SQL directly but this produces an error.
SELECT IP_SNAPSHOT_TABLE.ID,
IP_SNAPSHOT_TABLE.SSI_TABLE_NAME,
IP_SNAPSHOT_TABLE.SSI_SS_DESTINATION,
IP_DESTINATIONS.DEST_NAME
FROM IP_SNAPSHOT_TABLE INNER JOIN
IP_DESTINATIONS ON IP_SNAPSHOT_TABLE.SSI_SS_DESTINATION =
IP_DESTINATIONS.ID
This is such a simple thing to do I must be missing the obvious, can anyone help?
Thanks