Specified column is not accessible

[eudaimonia_]

Hi everyone, I have been stuck with my issue and I needed help.

Within Dataverse, I work with three tables: Table A, Table B, and Table C. Table A contains a lookup column connected to Table B. Table B, in turn, has a many-to-many relationship with Table C. Notably, Table A and Table C do not share a direct relationship. My objective is to create a collection that filters records in Table C, specifically those that match the records in Table B related to Table A. I have tried this 

ClearCollect(daxtm, Filter('TableC','TableC_ID' = TableA_ID.'TableB'.'TableC'.'TableC_ID'));

 but an error states that 'TableC_ID' in not accessible in this context. 

My objective is to create a collection that filters records in Table C, specifically those that match the records in Table B related to Table A.

TIA

[FLMike]

@eudaimonia_ 

The issue is how you are treating the MtoM in this type of query request

In this case you are also looking at the fact that there could be Multiple TableC_ID's associated to that B, but you are attempting to access it like its only one.. and that would not be possible. Question 1 was just to verify how you have your MM setup.

Remember since there could be multiple Cs in Tab, it can't be an =, it would be an IN

But gah sorry another dr, be back shortly 
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey