Access Database

[Christopher]

hi again,

New question.
I've created an example database with a table containing a field with lookup wizard to another table called Province. This is to make the input in the database easier.
Now in my ASP page I create my own filter. When showing the grid/form I get the id-province instead of the province name from te table. How can I get around this one?

Thx

Christopher

[Frank]

Chris,

Lookup is a V2 feature of ASPDB. V2 will display lookup value and also allow lookups in dropdowns. Do not use ACCESS's lookup feature. It's not standard. Use ASPDB's lookup (V2) and your code will be valid in ACCESS, SQL, ORACLE etc... no need to change !!

Frank

On 1/3/99 8:56:52 AM, Christopher wrote:
> hi again,

New question.
I've created an example database with a
> table containing a field with lookup wizard to another table called
> Province. This is to make the input in the database easier.
Now in my ASP
> page I create my own filter. When showing the grid/form I get the
> id-province instead of the province name from te table. How can I get
> around this one?

Thx

Christopher