I set up a Database/table in SQL 2000 and used an ODBC link to link to the external data in my Access 2003 project. The parent tracks Warranty Claims and the child Payments. I do not have a relationship set up in SQL.
I have a form set up with a continuous form subform. I add the parent record, and then add a child from the form. The first parent and child records are fine. The "freaky" part is when I add the second child record. I do the add with a third form (add payment form) When I close out after adding the new record I requery the subform. Immediately after that I check the data in the Enterprise Manager all looks good, it looks just like I entered it on the "add payment form". But when I check the data in the linked table in the MS Access Project. Here it duplicates the first child record instead of showing the new record. That is also how it is displayed on the parent/subform form after the requery. If I then move records on the parent form to the next record and back, it then displays the correct child records. At this time I go back to the Access Project to check the Child Table and that is still showing the data incorrectly.
I'm a bit confused! Any ideas would be great! Thanks.
I have a form set up with a continuous form subform. I add the parent record, and then add a child from the form. The first parent and child records are fine. The "freaky" part is when I add the second child record. I do the add with a third form (add payment form) When I close out after adding the new record I requery the subform. Immediately after that I check the data in the Enterprise Manager all looks good, it looks just like I entered it on the "add payment form". But when I check the data in the linked table in the MS Access Project. Here it duplicates the first child record instead of showing the new record. That is also how it is displayed on the parent/subform form after the requery. If I then move records on the parent form to the next record and back, it then displays the correct child records. At this time I go back to the Access Project to check the Child Table and that is still showing the data incorrectly.
I'm a bit confused! Any ideas would be great! Thanks.
