Hi,
I have a problem at a customer's site which is driving me crazy. It is a file whose first field is a numeric auto-increment field. I call it SEQ. It is the parent table to a child table. The child table uses the SEQ number as well as the link to the parent table. It will go along adding records into the parent and child tables fine with the SEQ number incrementing as expected. Then what will happen is that the customer will come back to the table and the parent table record will be gone but the child table records will still be there. What is even stranger is that if you look at the records in a browse you will actually see the position in the table where the missing record should be as a completely blank record. For example, if the three SEQ numbers were:
3508
3509
3510
When the customer returns to the table at some point in the future the browse will look like this:
3508
3510
The 3509 record will be completely blank but still in the table. All the fields in the table will be blank.
If I try to change an auto-increment number manually in this table it will not let me as I would expect. But I can't figure out how it is possible for the SEQ number as well as the other fields to be completely blanked out.
Does anyone have any ideas? Many thanks.
I have a problem at a customer's site which is driving me crazy. It is a file whose first field is a numeric auto-increment field. I call it SEQ. It is the parent table to a child table. The child table uses the SEQ number as well as the link to the parent table. It will go along adding records into the parent and child tables fine with the SEQ number incrementing as expected. Then what will happen is that the customer will come back to the table and the parent table record will be gone but the child table records will still be there. What is even stranger is that if you look at the records in a browse you will actually see the position in the table where the missing record should be as a completely blank record. For example, if the three SEQ numbers were:
3508
3509
3510
When the customer returns to the table at some point in the future the browse will look like this:
3508
3510
The 3509 record will be completely blank but still in the table. All the fields in the table will be blank.
If I try to change an auto-increment number manually in this table it will not let me as I would expect. But I can't figure out how it is possible for the SEQ number as well as the other fields to be completely blanked out.
Does anyone have any ideas? Many thanks.
Comment