I have been assigned to create a database. The information offered was to develop the database partly from ms Excel, therefore I established how to income the data and also create different tables that pertain to mine task.

You are watching: Relationship must be on the same number of fields with the same data types

I am, however, unable to create any relationships in between MS accessibility tables. I have double checked the the data types are the same between corresponding tables.

For example:

Table Vendor:

VendorID (autonumber) VendorName (short text)

...that i am do the efforts to affix to a seller field (short text) in ~ a Product detail table.

I think among the worries may be the there is duplicate information in the tables since the same merchants pop increase multiple times.

I have currently created a find query and form but the does not work: I suspect this is as result of a absence of relationships between tables.

ms-access relational-database ar relationship primary-key
enhance this concern
edited Dec 30 "19 in ~ 8:19

Scott Anderson
53144 silver badges2020 bronze badges
request Jul 7 "15 at 0:55

Mike KavMike Kav
2911 yellow badge11 silver- badge33 bronze badges
add a comment |

2 answer 2

active oldest Votes
Make certain you have actually your VendorID collection as the same datatype in both the tables.

N.B: also if that is stored as a number, make sure they are both long integers. The duplicates shouldn"t stop you from developing a relationship: duplicates limit only once you shot and develop a relationship v referential integrity.

enhance this price
edited Dec 30 "19 at 4:55

Scott Anderson
53144 silver badges2020 bronze badges
reply Jul 7 "15 at 18:42

Billy NorbuBilly Norbu
16888 bronze title
include a comment |
I had the exact same issue. In one table I had guestID together a primary vital with the AutoNumber format, and had a 1 to countless relationship through guestID in a various table. Ns must have actually put the style to brief Text by accident, so as soon as I readjusted it come Number, it removed the problem.

improve this price
answered might 25 "16 at 15:50

2,84866 gold badges3030 silver- badges5959 bronze badges
include a comment |

your Answer

Thanks for contributing an answer to ridge Overflow!

Please be sure to answer the question. Administer details and also share her research!

But avoid

Asking for help, clarification, or responding to various other answers.Making statements based upon opinion; earlier them increase with references or an individual experience.

To find out more, view our advice on writing great answers.

See more: On Average The Human Body Can Dispose Of The Alcohol In 12 Ounces Of Beer In About

Draft saved
Draft discarded

Sign increase or log in

authorize up making use of Google
sign up using Facebook
sign up using Email and also Password

Post together a guest

email Required, however never shown

Post as a guest


Required, yet never shown

article Your prize Discard

By click “Post your Answer”, friend agree come our terms of service, privacy policy and cookie policy

Not the prize you're spring for? Browse other questions tagged ms-access relational-database field relationship primary-key or ask your very own question.

The Overflow Blog
Featured on Meta
readjust an accessibility Primary key with relationships
how to develop multiple relationships between the exact same two tables in ms Access?
INSERT right into table by pulling data from one more table
In MS accessibility How come fetch data in the other row in very same table based upon what i pick in an initial row?
problem with relationships in access
update table and setup the ar values to the result of a left sign up with
Ensuring relationships stored in one MS access linking/relationship table are not allowed to overlap with respect come time
Can't identify relationships between the areas
Ms access relationship between two different type of ar
warm Network concerns an ext hot inquiries

question feed
subscribe to RSS
question feed To i ordered it to this RSS feed, copy and also paste this URL into your RSS reader.

ridge Overflow
ridge Exchange Network
site design / logo © 2021 ridge Exchange Inc; user contributions licensed under cc by-sa. Rev2021.10.26.40573

Stack Overflow works ideal with JavaScript enabled

her privacy

By clicking “Accept every cookies”, girlfriend agree ridge Exchange have the right to store cookies on your machine and disclose information in accordance through our Cookie Policy.