Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Translating Values

Quote Reply
Translating Values
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. Wink

How can I translate the stored IDNumber field to show the "County_Names' field on search results?

Thanks,
VanGogh
Subject Author Views Date
Thread Translating Values VanGogh 2251 Apr 21, 2005, 5:32 AM
Thread Re: [VanGogh] Translating Values
604 2166 Apr 21, 2005, 9:30 AM
Post Re: [TheStone] Translating Values
VanGogh 2164 Apr 21, 2005, 10:04 AM