It sounds like you're on the right track. What happens when you try writing a script to do this?
That's my problem. It's been many years since I did anything with it that I can't remember where to even begin.
I think the last time I made changes to a script was 2008.
Try doing the process manually, and writing down every step you take. Then try to create a script that follows those steps. Do you have FMAdvanced by any chance? If so, you can then step through the script and see what it is actually doing.
I see why I gave up on this years ago.
I can't figure out how to select that portal and it's row. I see an option for "Select portal row" but how do I get to that portal to begin with?
I'm running FileMaker Pro 6.0V4.
I've got my main file, and then 3 other portals linked to it. I need to get to my first portal, and select the top line as my first few steps but I can't figure out how to get there.
With multiple portals on a layout you need to provide FM with a means of distinguishing which one you mean in your script. The way you do this is to give the portal an Object Name and then use Go to Object just before Select Portal Row.
FMP6! Wow, that's getting old. It's a while since I used that version, but I'm pretty sure the above will still apply.
Ahh! Look's that way. In that case, a possible workaround could be:
1. create a separate utility layout to use for this script
2. place only the portal you want to work in on that layout
3. in your script, make the first step Go to Layout to navigate to that layout, then Select Portal Row should work, as there is only one portal available
Alternatively, remove the other portals from your original layout, but you probably don't want to do that.
Boss already OK'd a new copy of 14 for me.
He's usually good like that, but version 6 has been just chugging along so I never even thought about it, even running on Windows 10 64 now.
I'm sure going to 14 will have some growing pains, looks like I need to use a trial version of 11 to convert my files before going to 14 so we'll see. Glad it came up now, I didn't realize how old this version was.
It would be worth upgrading. There's been a stack of changes since FM6. As you say, you'll need to convert files twice, but it's usually pretty simple. Longer term, it would be worth considering a rewrite from scratch to take full advantage of the new features. It involves more work but you won't regret it.