if you browse the table at the end of the save code can you see the records you wrote ?
Chek the BufferModeOverride property of your form and of the tables you are using.

>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