Forum Discussion

VivekVishwanat2's avatar
VivekVishwanat2
Qrew Cadet
6 years ago

Relationship between A-B-C

Hi All,
I have a relationship A-B-C, where A is Master table and B is detail table.(one to many relationship); In the same way I have B-C relationship.

A table has 'n'  associated records in B, and B has 'n' associated records in C.
Can I get list of A's associated B records, in C Table's form? 




TableA     TableB     TableC 
A1             B1              C1
                  B1             C2   
                  B2             C3
                  B2             C4

A2              B3             C5


Form of C1 should show a table listing B1,B2,B3,B4 as they are associated to same 'A1'.
  • CharlieMurawski's avatar
    CharlieMurawski
    Qrew Cadet
    6 years ago
    Absolutely you can Vivek! You'll need to do a couple of things:

    1. Create a lookup of your foreign key/reference field for your A->B relationship in C so the value you have on your B records of Related A record now exists in table C
    1. Table A (Record ID#) -> Table B (Related A) -> Table C (Related A Lookup)

    2. Create a report link field in table C where you match records in table B with your new related A field in table C.

    I hope that makes sense!