I have two related tables (one to many), this relation is defined as a persistent relation on the database to provide referencial integrity, the relation is also defined in the dataenvironmet of the form and the properties of the grid are set for manage the relation too.

The init event of the form, appends records for both primary and secondary tables. The prymary table gets a unique default value. The value of the link field in the secondary table is repalced with the value of the fieldin the primary table.

When the form displays, the principal table controls, displays the new record, and the grid displays nothing.

With the debug window i can see that the record pointer in the primary table is set at the new record, but the pointer of the secondary table is at the end of file.

If ask to refresh the form or the grid, i get the record out of range error message.

I think that the relation it's not working, or the index files aren't updated when I insert the record.