
www.Usenet.com
| <-- __Chronological__ --> | <-- __Thread__ --> |
Hi Bit of an unusual one. I have an Access front end. Two tables tblHeader and tblDetails. Each has an ID field (unique and primary) plus other fields as necessary. On aform is 3 fields from the header: 1. A text field 2. A SupplierID field (combo dropdown) 3. A SupplierBranchID field (combo dropdown) The form is opened in "Add Only" mode. I enter "abc" in the text field and choose a supplier and branch. I then go to the sub-form (attached to tblDetails) and enter some details. I can happily close the form. If I open the form again (as above - Add Only mode), and put abc into the text field and choose the same supplier and branch, then the previous header is retrieved (which has "abc" in the text box, and the same supplier and branch), even though I want a "new" header record. A new header record *is* created, but not "used" (ie tblDetails has the "old" headerID inserted into it, rather than the "new" one.)I could also put in other records in between, but it always goes to the last record, with that same data in those three fields. Does this make sense? (considering that tblHeader has a uniquie ID field) Can anybody think of why/how this could happen. If I "uniquify" the text (eg add the date/time to it) then it is fine. Help! Regards, Mark ...
| <-- __Chronological__ --> | <-- __Thread__ --> |