Error while defining a secondary key

ajaybabuCh

Hi

when I am defining the secondary key in a table , I am getting the following error

The fields in an active key may not exceed 252 bytes. The size of the Primary Form Name,Entry No.,Primary Table No.,Linked Table No. key fields in the efin_LinkedTableInfo table is 264 bytes.
You must reduce the number or length of the active fields.

can anybody give me some idea on this

Thanks and Regards
Ajay

kapamarou

What is the size and datatype of the Primary Form Name field?

ajaybabuCh

datatype of text with 250 size

kapamarou

Reduce the field size...

I would rethink whether I need this field in the key. :?:

Belias

don't use text fields for the keys...use code datatype instead
anyway...it's really a long field for a primary key...can't you code the key in a shorter field and place this 250 text in a description field?

ajaybabuCh

thanks to everybody for giving the information