+ Reply to Thread
Results 1 to 4 of 4

relationships between table is needed

  1. #1
    Registered User
    Join Date
    03-09-2016
    Location
    Europe
    MS-Off Ver
    2010
    Posts
    16

    relationships between table is needed

    Hi all;

    I have created relationships between 3 tables, the pivot table works only up to a certain point.

    I have tab "Uniquesupplier" in which I have unique values.

    Then I have linked the supplier table with the spend & contracts table. When I add in the pivot table the "contract ID" from the table contracts is asking me to create a relationship.

    I do not understand what relationship I need to create.

    Thanks
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    12-06-2017
    Location
    Chicago, IL
    MS-Off Ver
    2016
    Posts
    19

    Re: relationships between table is needed

    You need to define the contract # each invoice is associated with.

  3. #3
    Registered User
    Join Date
    03-09-2016
    Location
    Europe
    MS-Off Ver
    2010
    Posts
    16

    Re: relationships between table is needed

    Hi;

    I have thousand of invoice lines and contracts are associated to supplier ID. in the example attached in the case of cablegroup I have 4 contracts associated to the supplier ID and not to the invoice.

    What relationship I can create so in the pivot table tab I can see: supplier ID - ERP Supplier - Spend - Contract ID - Proposed contract amount - contract expiration date

    Thanks

  4. #4
    Registered User
    Join Date
    12-06-2017
    Location
    Chicago, IL
    MS-Off Ver
    2016
    Posts
    19
    If you cannot connect the invoice to the contract, you cannot include the contract number in your pivot, because there can be multiple contacts for each supplier. Therefore, Excel would not be able to determine which of the multiple contracts any given invoice is associated with. Check your transactional tables. There had to be a contract number associated with the invoice.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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