I'm at wits end.
A simple form - parent & child (without grid) for new add's of Sales Employees:
Parent: Employ (employee serial number, first & last names, hire date)
Child: EmplDtl (salary, salary effective date, manager number, sales quotas, etc...)
A form consists of Employee S/N, names & hire date, bound to Parent Table, and salary, salary date, manager, quotas, bound to Child Table. After the Parent fields are entered and TableUpdate successfully, Child fields are enabled for entry. cmdSave (TableUpdate) saves the data into Child Table. The form works fine.
After the entries are successfully saved into the tables, I checked the tables. All looks fine. But when I set the relationship between Parent & Child, browse both tables, there is a duplicate grid row in the Child table (same record number). Strange behavior. Only the first row is editable, the duplicate row below it isn't. Changing a value in the first row would also reflect in the duplicate row below it. Why is this happening? I also have another form for these tables with grid to display child records as history. It would also show the strange behavior. Only if and when I pack the Child table would the problem go away! Why is this happening?
Thanks!
~d
J