relationships

[GeoffK]

Hi All,
I have 2 tables "Customers" where CustomersID is the key field and "Items"
where itemsID is the key field with another field customerID (both key fields
are autonumber). A one to many relationship exists between the 2 tables
[Customers]CustomersID to [Items]CustomerID.

This has worked well for several years, I am currently adapting this DB for
other uses and have encountered a strange problem.

When I enter data into the "items form" the customersID is entered into the
ItemsID field of the "Items Table" all the other data is stored correctly.

I have checked the relationships tables all is ok, I have created a query
and entered the 2 tables this displays the link this is also ok.

can anyone shed some light on why the customersID is entered into the wrong
field when the relationship is correct.

Thanks in advance
GeoffK

 

[John W. Vinson]

Hi All,
I have 2 tables "Customers" where CustomersID is the key field and "Items"
where itemsID is the key field with another field customerID (both key fields
are autonumber). A one to many relationship exists between the 2 tables
[Customers]CustomersID to [Items]CustomerID.

This has worked well for several years, I am currently adapting this DB for
other uses and have encountered a strange problem.

When I enter data into the "items form" the customersID is entered into the
ItemsID field of the "Items Table" all the other data is stored correctly.

I have checked the relationships tables all is ok, I have created a query
and entered the 2 tables this displays the link this is also ok.

can anyone shed some light on why the customersID is entered into the wrong
field when the relationship is correct.

Thanks in advance
GeoffK

Make a backup... NOW. Don't overwrite any older backups though! You may have
some corrupt indexes.

Once you have a backup, try Tools... Database Utilities... Compact and Repair
Database (it's under the Access button in 2007). See if that solves the
problem.

If not, see some more advanced solutions at
http://www.granite.ab.ca/access/corruptmdbs.htm