Max length for a column in a relation ?

[Adry]

Hi,

I've a relation between two datatable based on a column which contains
descriptions of 90 chars about.

Some descriptions differs only for the last 5/6 chars, so that the runtime
give me the error indicating that columns are not unique:
there's a max length for a column in a datarelation ?

Thanks

Adriano

 

[msnews.microsoft.com]

Not sure there is a limit, but it is not wise to join on text fields, much
less long text fields. If you can normalize the data a bit with an ID field,
you will find this much less painful.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************