reference: This has been carried over as a new item from an earlier posting by me at:
http://www.lantica.com/Forum2/cgi-bin/yabb/YaBB.pl?board=gen_disc;action=display... , subject = Elements not saving data.
=====================================
Using the following programing as reference:
Quote:IF @ISBLANK(Record) THEN {
Record = @TN(@XLOOKUPR(@FN,999999,"frmName!Record","Record")) + 1
}
If there are 10 records in the database, then each one has a unique record number, 1-10. If I add a new record, it will become record number 11. (Do not actually add the record, just confirm what the value will be).
However, if I delete records, 6-10 first, then I only have 5 records, each with its unique record number 1-5. If I now add a new record, it will become record number 11. But I really expect it to become record value = 6. This should not be happening.
Sesame seems to be working as if these records were never deleted. The XLR command seems to be looking at deleted records. Are records actually being deleted, or are they just being tagged internally as deleted? Is there a process that needs to be done after "deleting" records to have them really fully deleted?
I have confirmed this in two forms in two different databases.