Forum Discussion

sshweky's avatar
sshweky
Helper III
10 years ago
Solved

Relationship issue

Hi Everyone - I've been on trial and error for 3 days & I cannot fix this! Here's the situation:

 

I have 2 divisions in my company and I am trying to track sales, inventory, on order, in production & chargebacks from the customer. I created a table called 'year' that would connect to all the tables to filter out a specific year.

SEE TABLE STRUCTURE & VISUALIZATION BELOW. 

The problem is that when I filter out by division or specific customer, the fields from the 'Chargebacks' table go BLANK and I kow they are not blank. There is definitely a relationship issue but I cannot figure it out.  Please help!!!!!

 

If you want to talk by phone let me know. THANK YOU!!!!!!!!!!!!!!!!!!!!!!

 

 

  • Hi,

    I may be able to help, but I can't read the text in your model. Can you resend so I can read it please and I will try and help you.

     

    Kind Regards,

     

    Kieran.

5 Replies

  • Hi,

    I may be able to help, but I can't read the text in your model. Can you resend so I can read it please and I will try and help you.

     

    Kind Regards,

     

    Kieran.