Invalid Field Definition

[Guest]

In Access 2003, I am getting an error message: "Invalid Field definition
'RecordID' in definition index or relationship."
This is where 'RecordID' is the name of a key field that links two tables
using AutoNumber. I have looked at both tables, using Design View. I have
also looked at the Edit Relationships box. It appears to me that there are
no typos anywhere that I am using the 'RecordID' field name.
I'm assuming the problem is a typo, hidden somewhere.
Any suggestions on how to proceed?

 

[Douglas J. Steele]

Are you saying that RecordID is an autonumber in both tables that you're
trying to relate? That won't work: one of them needs to be a Long Integer.

 

[Guest]

Here’s what I have: A “Main Contacts†table that contains the primary key
“RecordID.†A second table, called “Telephone_FAXâ€, contains the foreign
key, “RecordID.â€

Using Design View, I see the same settings in *both* tables: In the
Description pane the Data Type is AutoNumber for the “RecordID†field (Long
Integer is not an available option). Beneath the Description pane, both
tables show the Field Properties pane, General tab, where the Field Size for
*both* tables is listed as Long Integer.

Are you saying that RecordID is an autonumber in both tables that you're
trying to relate? That won't work: one of them needs to be a Long Integer.

 

[Douglas J. Steele]

The Data Type for one of them needs to be Number with Field Size of Long
Integer.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Here's what I have: A "Main Contacts" table that contains the primary key
"RecordID." A second table, called "Telephone_FAX", contains the foreign
key, "RecordID."

Using Design View, I see the same settings in *both* tables: In the
Description pane the Data Type is AutoNumber for the "RecordID" field
(Long
Integer is not an available option). Beneath the Description pane, both
tables show the Field Properties pane, General tab, where the Field Size
for
*both* tables is listed as Long Integer.

 

[Guest]

Ah, yes... Access seem much happier now. Thanks!

Are you saying that RecordID is an autonumber in both tables that you're
trying to relate? That won't work: one of them needs to be a Long Integer.