Forum Discussion

jasonwq's avatar
jasonwq
Helper I
5 years ago

Relationships between three tables.....

Hi. I've got a complicated relationship between three columns that I don't know how to describe. Here's what they look like..

 

Tables

1. (IC) Item Card

2. (VC) Vendor Card

3. (VIC) Vendor Item Catalogue

 

IC Item Number (unique)IC Default Vendor NumberIC Lead Time 1

 

VC Vendor Number (unique)VC Lead Time 2

 

VIC Vendor NumberVIC Item NumberVIC Lead Time 3

 

The VIC card can look like this:

 

VIC Vendor NumberVIC Item NumberVIC Lead Time 3
Vendor1Item11W
Vendor1Item22W
Vendor2Item13W
Vendor2Item24W

 

There are no unique fields in the VIC card. It's a combination of the VIC Vendor and the VIC Item that is unique.

 

I'm looking to create this report:

 

IC Item NumberIC Lead Time 1VC Lead Time 2VIC Lead Time 3IC Default Vendor Number
Item 1***Vendor*
Item 2***Vendor*

 

I'm close....

 

But currently I'm getting multiple instances of the Item# because i've linked the:

 

IC -> VC  - through Item No

IC -> VIC - through Vendor No

 

I really want to say, only return VIC rows if the Item AND the Vendor match what you see on the IC Item# and IC Vendor#

 

 

Any ideas?

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi jasonwq ,

     

    Can you share the data model? Your expected report and the screenshot look different. And the logic of your requirement is not quite clear.

     

    Best Regards,

    Jay