I’m wanting to create a list of all the records for my main object that I can export but I’m also needing want to include another secondary object with this export. my main object has a one to many relationship with the secondary object, is there a way to do this from the list or would I need
Hi Alex, just to check that I’m understanding you correctly. Are you saying you have one record in your main object that is potentially linked to more than one record in a secondary object via a 1-2 relationship and you need to see the information from the secondary object, displayed in some way?
If so, are you wishing to see a repeat of the primary record, for each instance of a relationship to a secondary object record? Or do you want to export just one instance of the primary record with all the secondary information listed as lines below the primary record information?
Please get back to me and I’ll try to give you some options.
Regards - MP
Hi Mark,
Yes that is correct, I’ve been asked if we can export all the records from the main object and include all the associated secondary object record with each of the primary record.
I have found that I can get the secondary object information into a list using the concatenated list aggregate however I’m not overly keen with how it looks but do understand if that is the only way to do it in the way I am trying
So, for example if Record 1 in the primary object was linked to three secondary object records that contain data you wish to export, would you want to see three instances of the primary record, each displaying one of the three associated secondary records?
Regards - MP
No, I’d want a single instance of the primary record with all the associated secondary record
So your listing would look like this?
Primary record 1 : Desk D1:
22.01.2026 - Mike Smith - Acme Corp - 10.00 - 15.00
23.01.2026 - June Brown - Smedleys Ltd - 09.00 - 17.30
24.01.2026 - Alan Smith - Wright and Co - 12.00 - 14.00
Primary Record 2: Desk D2: etc etc
Regards - MP
Yes a listing like that would work