Jump to content

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


This topic is 3005 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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)

FM_portal.thumb.png.861c47747b74f780710f

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.

excel_output.thumb.png.9374be865c447b386

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 3005 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.