relation problems between tables. cant get the right data
I have a relation between tables as in the image. Same alphabet shows the same field in different tables.
I have a layout from Table 1 which includes a portal from Table 3. In the portal, I want to have Field F from Table 5. But I get the same data in this field for every record in the portal. But they should be different. I also want to set filter option to the portal where Table 1:Field B=Table 5:Field B