+ Reply to Thread
Results 1 to 3 of 3

Can not create relationship between Tables (not many to many)

  1. #1
    Registered User
    Join Date
    06-26-2018
    Location
    united states
    MS-Off Ver
    1711
    Posts
    3

    Can not create relationship between Tables (not many to many)

    Hi guys,

    I seems to run into a fairly simple problem but somehow I can not figure it out.

    I need to create a relationship from 2 tables. The common column is SKU_Number (as image)

    The relation is just one to one but everytime I add SKU_Number from one table and unit price from the other, it can not map a relationship. The unit price from the other table return error.

    Please help me with this.

    Thank you.

    Relationship.PNG
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-06-2012
    Location
    sydney, australia
    MS-Off Ver
    Excel 2016
    Posts
    5

    Re: Can not create relationship between Tables (not many to many)

    Hi vipe110,

    Refer to the attached spreadsheet corrected for the solution.

    Note: SKU table had Z12 with blank spaces.

    Cheers
    Krishna
    Attached Files Attached Files

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Can not create relationship between Tables (not many to many)

    @indkitty
    Sorry for off-topic interjection:

    Although there is no official rule regarding this behavior, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

    I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

    Thanks again for all your hard work here!
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 03-05-2020, 11:37 AM
  2. Replies: 0
    Last Post: 07-08-2016, 12:20 PM
  3. linking tables with a relationship instead of vlookup
    By Atomic BI in forum Excel General
    Replies: 0
    Last Post: 03-29-2016, 12:48 PM
  4. Replies: 0
    Last Post: 03-18-2015, 02:59 PM
  5. [SOLVED] What am doing wrong? Creating a relationship between two tables.
    By BrownBoy in forum Access Tables & Databases
    Replies: 2
    Last Post: 07-18-2014, 11:52 AM
  6. Replies: 4
    Last Post: 09-13-2012, 09:08 AM
  7. Relationship between Cell and Data Tables
    By NeshaNYC in forum Excel General
    Replies: 0
    Last Post: 08-15-2011, 10:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1