>No, the table does not have a primary key. The Memos whithin a group are also equal to the last character.
>
>The table could have this values:
>
>F1, F2, F3, F4, F5 (memo)
>Walter Meier, Hallo Walter, 20120101, 20121231, complete adress with multible lines for Walter Meier
>Walter Meier, Hallo Walter, 20120101, 20121231, complete adress with multible lines for Walter Meier
>Walter Meier, Hallo Walter, 20120101, 20121231, complete adress with multible lines for Walter Meier
>Walter Meier, Hallo Walter, 20120101, 20121231, complete adress with multible lines for Walter Meier
>Gesine Huber, Liebe Gesine, 20120101, 20121231, complete adress with multible lines for Gesine Huber
>Gesine Huber, Liebe Gesine, 20120101, 20121231, complete adress with multible lines for Gesine Huber
>Gesine Huber, Liebe Gesine, 20120101, 20121231, complete adress with multible lines for Gesine Huber
>
>What I need is a table like that:
>Walter Meier, Hallo Walter, 20120101, 20121231, complete adress with multible lines for Walter Meier
>Gesine Huber, Liebe Gesine, 20120101, 20121231, complete adress with multible lines for Gesine Huber
>
>TIA
>Gerhard
>
>
If the information in the memo is less than 254 characters, then you can use these 254 chars and use distinct. Otherwise there is no way without a primary key.
If it's not broken, fix it until it is.
My Blog