> > > > Every, every!, absolutely each and every, table in a relational system must have a primary key, a unique key, in one or a combination of more columns. > > What's the PK of your table?> > Such a column is safeguarded by the system through a Primary Key index or a Candidate (Unique) index. See the commands CREATE TABLE and ALTER TABLE in the documentation. The MODIFY STRUCTURE window is a visible tool and can create those indexes too. > > I'm sorry but I don't understand upper and lower limits in this scenario. > > How do you maintain correctness of 'long text?> > > > -Anders> > > chart of accounts | gl account group | number of G/L account (lower area limit) | number of G/L account (upper area limit) | long text :: Caption> ktopl | ktoks | vornr | bisnr | text30 :; field name> -----------------------------------------------------------------------------------------------------------------------------------------------------> CAPE | ADCU | 0014390000 | 0014399999 | Advance from customers> CAPE | ADIC | 0025010000 | 0025019999 | Advance Inter Company> CAPE | ADIN | 0025000000 | 0025009999 | Advance Inter Unit> CAPE | ADMS | 0025200000 | 0025299999 | Advance for Material / Servic> > index on ktopl with candidate key.> index on ktopl+ktoks with candidate key.> > I would like to prevent any number range which is falling between any number range already exists for every ktopl.> > > Individual gl account will be opened between the number mentioned in another table, such as:> > chart of accounts | gl account group | number of G/L account | long text> ktopl | ktoks | vornr | text30> ---------------------------------------------------------------------------> CAPE | ADIC | 0025010012 | (Name of a company)> CAPE | ADIN | 0025000336 | (Name of a unit)> > : Valid Record : since the vornr number is between 0025010000 and 0025019999.> > CAPE | ADIC | 0014390059 | (Name of a company)> > : Invalid Record, since the vornr number is not between 0025010000 and 0025019999 for every ktopl and ktoks.> > Account posting will be made based on the last table.> > Regards,

The Candidate index on the column 'ktopl' is not working. There are four duplicate values 'CAPE'. To find if a vornr is ok: