Active fields in a record may not take up more than 4000byte

upasanisandip

Hi all,
Is there limitation for adding fields in table upto only 4000 bytes?

I am getting following meesage while adding fields in 1 table.
Active fields in a record may not take up more than 4000 byte.

Thanks,
sandip.

Miklos_Hollender

Yes. This why f.e. when clients want to add a lot of product specification fields to the Item card I create a table called Item Configuration, linked to the Item by primary key.

diptish.naskar

You can go through the pdf of navision and find the same, its mentioned there also.

DenSter

Two commo approaches:

1:
Miklos' appproach. This is the most flexible one, although you really want to prevent one-to-one relationships in a relational database, they are a pain to maintain.

2:
disable fields that you're not using. This is a very dangerous approach, because you'd be in trouble if your customer ever decides to start using that field.