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
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.
FROM IP_SNAPSHOT_TABLE INNER JOIN
IP_DESTINATIONS ON IP_SNAPSHOT_TABLE.SSI_SS_DESTINATION =
This is such a simple thing to do I must be missing the obvious, can anyone help?