FileMaker Back Button by RecordID
Posted on 2008-06-13
I need a back button, and it's not going to be easy.
The db I'm working on has >40 tables with over 100 layouts and (far too) many self-joins. I've installed Back Magic from Seed Code, but that only restores layouts and tabs, not individual records. The rest of the road I'm on has me stuck.
I tweaked back magic to store RecordIDs, as they are the only thing I can think of that is a universally accessible (meaning I don't have to specify what table::field I'm looking in), constant, unique identifier. So how do I get there? The self-join via global calc field method is impractical, as is using any single field name (all the table specific record ids are uniquely named and I really don't want to script a case statement that runs through every possible layout to determine which table and field to look at).
So, the only thing the internet has turned up as viable thus far is.... apple script. Here's what I have:
"set thisID to \"" & $recordID & "\" " & ¶ &
"tell application \"FileMaker Pro\"" & ¶ &
"tell database \"LR_Database\"" & ¶ &
"show record ID thisID" & ¶ &
"end tell" & ¶ &
and it works.... half of the time. The other times I get "Object Not Found" and "Unknown Error: -1728" anyone know why? anyone have any other ideas? If it can't be done in 30-45 minutes with less than 5 new table occurances, I can't do it.