Link to home
Start Free TrialLog in
Avatar of dannyboy266
dannyboy266Flag for Afghanistan

asked on

access 2007 "Invalid field definition 'CustomerID' in definition of index or relationship

I'm getting a error saying

"Invalid field definition 'CustomerID' in definition of index or relationship

when trying to link and enforce integrity between CustomerID on 2 seperate tables, in the pic it's tblCUSTOMER_INFO and tblSHIP_INFO
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

"in the pic it's tblCUSTOMER_INFO and tblSHIP_INFO"

in what 'pic' ?  Not following.

And for good measure, try a Compact and Repair of the database.

mx
Avatar of dannyboy266

ASKER

oooops sorry skipped the attach step
accessdb.jpg
Still not seeing  "tblCUSTOMER_INFO and tblSHIP_INFO""

?
it's the two top tables in the relationship view pic i uploaded, i try and connect the customerID fields and I get that error.
sorry ... that's the table names.

ok ...can you first try the Compact and Repair ...occasionally that will fix this issue.

If not, can you convert to A2003 format and upload ?

mx
Ok sure, the compact and repair didn't work, here's the 2003 file.  

just change the .txt extension to .mdb
BorundaInvoice1.txt
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Awesome, thanks for the quick fix MX
"Awesome, thanks for the quick fix MX"

You are welcome ...

mx