Misplaced records

[Guest]

I have an order placing database. Some of the products that were placed for
an order somehow show up in another order. Any idea what might be causing
this?

Thanks!

 

[Guest]

In order of likelihood from most to least:

1. Users entered the data incorrectly. If the users deny this remember this:
Users lie.

2. Bad database design with things like many-to-many relationships between
tables.

3. Database corruption. Unlikely given the symptoms you described.

 

[Guest]

1. The data is entered correctly.
2. All the relevant relationships are set properly to one-to-many

Any other ideas?

Thanks!

 

[John Vinson]

I have an order placing database. Some of the products that were placed for
an order somehow show up in another order. Any idea what might be causing
this?

Thanks!

What's the OrderID (or whatever the foreign key might be) for the
"misplaced" records?

You might have a corrupt Index; Have you tried Tools... Database
Utilities... Compact and Repair?

John W. Vinson[MVP]

 

[Larry Linson]

1. The data is entered correctly.
2. All the relevant relationships are set properly to one-to-many

Any other ideas?

Give some details of the Tables, data, and how the Forms are set up for data
entry. Are there circumstances where the data is properly saved? What are
the differences between those and the circumstances where it is not?
Clearly, if _everything_ were OK: design, implementation, and data entry,
then you wouldn't be getting data associated with the wrong records.

There is, of course, no "put data in random records" option in Access, but
small glitches in design and implementation could cause that to happen.

Larry Linson
Microsoft Access MVP