Encoded dbEditDropFields

[Abb Kestler]

In updating a database with "coded values" I need drop down fields that allow selection by a text field but insertion of a corresponding code. Only the code is stored in the subject table.

The text and associated code are stored in a separate table and used via joins, etc.

I can't find any examples of this on the ASPdb site nor in your manual. Any ideas?

Thanks,
Abb

[Frank]

Abb,
Abb,
Sounds like you are talking about a lookup dropdown. Like displaying Michigan but actually table contains value of MI. If that is the case, a full lookup feature including display will be available in V2 of ASPDB. This is a very complicated subject in the perspective of ASPDB's MagicCell.

Frank


On 10/30/98 9:59:17 AM, Abb Kestler wrote:
> In updating a database with "coded values" I need drop down fields
> that allow selection by a text field but insertion of a corresponding code.
> Only the code is stored in the subject table.

The text and associated
> code are stored in a separate table and used via joins, etc.

I can't
> find any examples of this on the ASPdb site nor in your manual. Any
> ideas?

Thanks,
Abb

[Abb Kestler]

What you're doing is great but I should have been talking about multicolumn dropdowns. I saw your answer to the same question submitted right after mine.

Thanks

On 11/4/98 8:46:44 PM, Frank wrote:
> Abb,
Abb,
Sounds like you are talking about a lookup dropdown. Like
> displaying Michigan but actually table contains value of MI. If that is the
> case, a full lookup feature including display will be available in V2 of
> ASPDB. This is a very complicated subject in the perspective of ASPDB's
> MagicCell.

Frank


On 10/30/98 9:59:17 AM, Abb Kestler wrote:
> In
> updating a database with "coded values" I need drop down fields
>
> that allow selection by a text field but insertion of a corresponding code.
>
> Only the code is stored in the subject table.

The text and
> associated
> code are stored in a separate table and used via joins,
> etc.

I can't
> find any examples of this on the ASPdb site nor in
> your manual. Any
> ideas?

Thanks,
Abb