Skip to main content
Question

Relationship between A-B-C

  • July 30, 2019
  • 0 replies
  • 19 views
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'.
      This topic has been closed for replies.

      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!
      Terms & ConditionsAccessibility statement