Portal exported to excel spreadsheet only contains one related field once, other fields are empty

[justakid]

Hi All,

Sorry if the title is a bit confusing, I wasn't sure how to explain it.

Basically I've got a layout that contains a portal to another table. abc0198_cpa_v002 and xyz0570_cpa_v0008 are the link to the other table (linked to the table by the first 6 characters)

the problem I have is when I export this I get the following in Excel. I was hoping that the empty fields beneath abc0198_cpa_v002 would be filled with abc0198_cpa_v002.

I can get it to work by going to the related table, searching for those records (abc0198 & xyz0570), but I will fall into the same problem when I receive multiple records that relate to the same record in the other table. IE I might receive abc0198_cpa_v002 and abc0198_cpa_v005 etc.

I hope this makes sense and thanks in advance for any help.

[comment]

36 minutes ago, justakid said:

I can get it to work by going to the related table

That would be the correct path to take.

 

37 minutes ago, justakid said:

searching for those records (abc0198 & xyz0570),

If you already have a found set in the parent table, you can use GTRR [Match all records in the current found set] to establish the corresponding found set in the child table.

 

40 minutes ago, justakid said:

but I will fall into the same problem when I receive multiple records that relate to the same record in the other table

I am afraid you've lost me here.