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, an...
Forum Discussion
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
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!
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
- 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!