Greetings,
I have setup several relationships with small, secondary tables from my main table. And they all work as expected, except when it comes to showing search results.
Example:
I have a secondary table called 'Counties' with two colums 'IDNumber' and 'County_Name'. The IDNumber is the key. It is related to a column on my main table called 'County'.
When adding a record, a pull down list exists showing the user-friendly 'County_Names' to the user to select from. But when the results are shown from a search, they see the 'IDNUmber' instead. And while I know that '17' means Miami County, they don't.
How can I translate the stored IDNumber field to show the "County_Names' field on search results?
Thanks,
VanGogh
I have setup several relationships with small, secondary tables from my main table. And they all work as expected, except when it comes to showing search results.
Example:
I have a secondary table called 'Counties' with two colums 'IDNumber' and 'County_Name'. The IDNumber is the key. It is related to a column on my main table called 'County'.
When adding a record, a pull down list exists showing the user-friendly 'County_Names' to the user to select from. But when the results are shown from a search, they see the 'IDNUmber' instead. And while I know that '17' means Miami County, they don't.
How can I translate the stored IDNumber field to show the "County_Names' field on search results?
Thanks,
VanGogh
Translating Values