Be careful of using the defaulted relations...1st, the default relation is one-to-one, so make sure that's correct. And make sure that the correct table is the parent and the correct table is the child.

This is all probably just fine, since you don't have any complaints about the relations...Are you sure you're appending blank in the table you *think* you are? (Sorry, but I don't really know what else to ask at this point.)


>I have my tables and relations defined in the database container. When I add the tables to the data environment of the form, the relations are set automatically. They appear to be OK. My form is one-many-many and the relations and refreshes are working great. The only thing that does not seem to behave is the focus not being on the appended record in the grid. Any other suggestions would be appreciated.