Condition limit for key table

[Former Member]

Hi

I want to create a condition table in V/05 and I can't add to this primary key with size bigger then 100. How can I add my own field into table A* with more length of fields. It is possible to add own field not in primary key or something?

[Jelena_Perfiljeva]

It is not feasible. 100 characters should be more than enough. If it's not, you might want to re-think your design. Condition records are supposed to be based on just a few key fields, which shouldn't be that long. Why do you need so much space?

[Former Member]

I must add to this condition some text fields, this is a reason and in table KONP there aren't any for this.

[Jelena_Perfiljeva]

Conditions should not be based on the text fields, only on the unique identifiers, such as material # or customer #. For example, if you base a condition on a material description and later someone changes the description, the condition won't work. The material number, on the other hand, cannot be changed. This is like database table design 101. Not even to mention the language aspect of the text fields.

Change your design to use unique (and short) identifiers.

[Former Member]

Everything is clear but how can I add longer text fields into this condition tables? This texts must be connected with conditions.

Edited by: Kosmo on Oct 28, 2009 7:22 PM

[Jelena_Perfiljeva]

You can't do this. Not sure how I can explain this any clearer...