I posted recently about two fields not acceptiing keystroke entries after months of trouble-free use. one of those fields is now posting entered keystrokes into the same field of another, unrelated record. I found this out by sorting for a last name, and these two showed up with about ten others that are not affected by it. Entering the single keystroke in that field in either record produces a change in the other. I have compacted and repaired the database(s), but it still happens. Any ideas?
It is probably by design if the two fields are in different tables. You likely have relationships set up to enforce referential integrity between each of the tables underlying the two fields. Are youy sure the two table records are not related?
If they are truly not related, then you probably need to change the relationship between the two tables via the relationship button on the toolbar.
However, you should be aware, that a normalized relational databases like Access consists of many one-to-many relationships between the data tables. For example, consider the one to many relationship Order table and Order detail table......Each order has many details. In order to assure that the Order Details are properly matched to the correct Order, a relationship is set up and enforced on the Order#.