Invalid Field Definition

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tmdrake - 31 Oct 2007 19:14 GMT

When trying to build a relationship betweet two tables, I'll received the
error message "Invalid Field Definition "ID' in definition of index or
relationship. I have checked and rechecked the 'ID' field, but can't seem to
locate the problem.

So what does this error mean? and How can I fix it?

Thanks

Signature

tmdrake

Reply to this Message

Pat Hartman - 31 Oct 2007 20:00 GMT

It sounds like the two fields have different data types or field lengths.
Make sure their data types are the same - exception-autonumber PKs join to
Long Integer FKs and if the type is text, make sure the lengths are the
same.

> When trying to build a relationship betweet two tables, I'll received the
> error message "Invalid Field Definition "ID' in definition of index or
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message

Maurice - 31 Oct 2007 21:35 GMT

Probably a invalid reference to the wrong foreign key. Can you explain the
fields you are trying to relate to eachother? Try to give your ID fields a
proper name that way you can identify them better when trying to create the
relationships in the relationship window

Signature

Maurice Ausum

> When trying to build a relationship betweet two tables, I'll received the
> error message "Invalid Field Definition "ID' in definition of index or
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message