Hi Folks, I attached an MS ACCESS 2003 database which I use in my application. I also attached several procedures I use in conjunction with the ADO table. Now I have this field, Number which should only reflect the number of customers. This is where something goes wrong.
Let's say I have 10 customers, then it nicely displays number 1 to 10. But when I jump from the first customer to the last, it changes the number 10 into number 1. So then it reads 1-2-3....8-9-1. When I jump back to the first customer it changes it back to 10 again. Now at first I tried to solve this by disallowing duplicates, thus indexed yes( no duplicates).
But this caused some problems since I already had an index yes no duplicates field I believe. Can someone solve this problem?
// this is the procedure which provides the numbering
procedure TForm1.tblKlantenCalcFields(DataSet: TDataSet);
Dataset.fieldbyname('Nummer').value := max(dataset.RecNo, 1);