Related tables - two tables that won't relate
Results 1 to 3 of 3

Thread: Related tables - two tables that won't relate
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Related tables - two tables that won't relate

    Hi all,
    I have two tables.

    1 - contains project profitability data.
    It contains the period end date and the project number and name with the relevant data against (many many rows)
    The above three criteria will duplicate in the list as a new months information is pasted into the rawdata

    2 - contains accounts receivable data
    It contains the period end date and the project number and name with the relevant data against (many many rows)
    The above three criteria will duplicate in the list as a new months information is pasted into the rawdata

    Problem:
    I can't link the tables uniquely as i get a duplicate error.
    I have tried to create a 3rd table removing the duplicates in the project number and connect the two tables this way, however, they still won't appear as related.

    Any help in the process to connect these two tables would be great.

    Thanks,

  2. #2
    Board Regular
    Join Date
    Apr 2014
    Posts
    79
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Related tables - two tables that won't relate

    What should the desired results look like?

  3. #3
    New Member
    Join Date
    Jul 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Related tables - two tables that won't relate

    Hi Bobby,
    I need to take:
    project name (which is also duplicated), date from the 1st table.
    Invoice number and balance from the 2nd table
    and put into one pivot table

    Thanks

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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