May 17, 200619 yr A user of mine swears blind that he used to Export the Records from a layout that has a portal on it, and he would end up with a tab separated file that had all the records from within the portal in it.. His end result would loook like this: main record 1 portal record 1 main record 1 portal record 2 main record 1 portal record 3 main record 1 portal record 4 main record 2 portal record 1 main record 3 portal record 1 main record 3 portal record 2 main record 3 portal record 3 Currently though, when using the Export Records menu command.. he's only getting this: main record 1 portal record 1 main record 2 portal record 1 main record 3 portal record 1 He's trying to get the export to yield a data set similar to the first set (complete with all the data in the portal) Could someone tell me if this is possible by using the Export Records menu command and what might be preventing him from exporting all the portal data with the main record data ? Thanks p.s. I told him about the wonders of Get Related Records script step but for the time being we're just wondering if he /can/ do this just with the Export Records menu command.
May 18, 200619 yr If you export from a layout of the Child table, and include the Parent field, you will get a result similar to your first example.
Create an account or sign in to comment