MS Access database support

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Access 2000

Ken

2006-02-17, 8:24 pm

I am new at this. The database is working correctly stores data except when
editing some data.

I created an InformationTable with all variables.

Then used the Analysis Wizard to create 5 specific tables.

The Wizard then created the Query, CustomerInformationT
able.

I previously had 15 items in the InformationTable when I started adding
additional variables.

The problem is when I edit one item, say contact name, and save the record,
all the records are updated with the new contact name instead of just the
specific record.

The individual table, ContactName only shows two records. The Query,
CustomerInformationT
able, has added the new data on all records including
the original 15 records instead of just the record changed.

I would appreciate any suggestions on solving this problem.

Thanks.

Ken

Sponsored Links