Error: Relationship must be on the same number of fields with the same data types

Posted on 2007-10-16
Last Modified: 2013-11-27

I am trying to create referential integrity between two tables. (One-To-Many Relationship)
One table has a primary key - DocID
The other table has the same field - DocID.
Both data types are NUMBER.
Why does it keep giving me this error??? It's so frustrating!!!

Question by:jenica024
    LVL 65

    Accepted Solution

    Numer - What?  Integer, Long Integer, Currency, ...   they must match

    Also, if your checking the referential integrity checkbox, then the existing data must comply with that relationship.
    If you have a number in the 'many' table that is not in the 'one' table, then you'll have to resolve that before you can establish referential integrity.

    Author Comment

    You're absolutely right.
    Sorry. I forgot to check the type of number it is.
    Got so many things going on. :)

    Thanks loads!
    LVL 65

    Expert Comment

    by:Jim Horn
    Thanks for the grade.  Good luck with your project. -Jim

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now