Yes, you can GTRR as long as you have the relationship setup in FileA correctly.
So if I go into GTRR and I select the self join TO, then I choose a layout, it only shows layouts in FileA, and doesn't show any layouts in FileB (even though I want the same table).
Hmmm, I wonder if I open FileB and then calculate the layout name, then it might work.
Did you select the "use external table's layouts" option?
It's greyed out since I'm not choosing an external table. I'm choosing an internal table, but want an external file.
I did add the TO to the external file, but can't access that from GTRR unless I am already in that file.
IF you have a TO to a table in the external file, then you can refer to it in the GTRR and use this option.
But I think I see the problem. This isn't an external table, it's a local table in this file and an external table in the other. And you want to replicate the found set of your current file's TO in the external file's layout(s).
That would explain the need to build a list of ID's to use to pull up the correct records in the other file.
Yes, that would be the case. (Except that only dealing with 1 table, because I'm using the same table in both files. The table just happens to be local and not external.)
I suppose it's not a huge deal since I will be dealing with < 500 contacts, but I thought I would ask.
There are several options worth evaluating:
You can use copy/paste to reproduce the layout(s) in the second file in your first file: Importing Layouts
If you are performing a find to pull up the contacts in file 1, you may be able to perform a script in file 2 where you pass the same search criteria in a script parameter to a script for finding these records on the File 2 layout. That might be faster/simpler than building a list of ID's for the same purpose.
This is good to know for future reference. Thank you very much
I just realized, however, that the (sub)script in the external file needs the list of Contact ID's anyways, so I'm just going to pass that list as a parameter (and skip the part of needing a found set). *sigh*
I do like the passing the search criteria thing, though. : )