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
share
enhance this concern
monitor
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
3
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.


share
enhance this price
follow
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 |
1
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.


re-superstructure
improve this price
monitor
answered might 25 "16 at 15:50
*

MichaelMichael
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
send

Post together a guest


name
email Required, however never shown


Post as a guest


name
email

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
connected
1
readjust an accessibility Primary key with relationships
4
how to develop multiple relationships between the exact same two tables in ms Access?
1
INSERT right into table by pulling data from one more table
0
In MS accessibility How come fetch data in the other row in very same table based upon what i pick in an initial row?
2
problem with relationships in access
0
update table and setup the ar values to the result of a left sign up with
0
Ensuring relationships stored in one MS access linking/relationship table are not allowed to overlap with respect come time
0
Can't identify relationships between the areas
1
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
assets
company
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.