When we click on SAVE we flush all buffers.
>You mean that people don't exist in the child table?
>If so,
>Are you sure they was really insert into table ? maybe you worked in buffered mode and miss some tableudate or end transaction command.
>
>
>>We have a parent/child database system.
>>
>>Parent is Companies
>>Child is People
>>The link is the ID which is manually entered for the company then automatically generated for the people.
>>
>>Is there any known way for people to be missing from the people table, if the data was saved?
>>
>>I have looked at the table seperately...the names are gone.
>>I have looked at the deleted records.
>>The table was NOT packed.
>>
>>We did reindex with INDEX ON all the indexes.
>>We did not kill and recreate the tags.
>>We did look for the data without any indexes however.
>>
>>Is this possible?
>>Would putting the data into MS SQL make it more secure from the above?
>>
>>Glenn
Glenn