dannyboy266
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
"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
ASKER
oooops sorry skipped the attach step
accessdb.jpg
accessdb.jpg
Still not seeing "tblCUSTOMER_INFO and tblSHIP_INFO""
?
?
ASKER
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 ...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
ASKER
Ok sure, the compact and repair didn't work, here's the 2003 file.
just change the .txt extension to .mdb
BorundaInvoice1.txt
just change the .txt extension to .mdb
BorundaInvoice1.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Awesome, thanks for the quick fix MX
"Awesome, thanks for the quick fix MX"
You are welcome ...
mx
You are welcome ...
mx
in what 'pic' ? Not following.
And for good measure, try a Compact and Repair of the database.
mx