make it the only record in the found set?
Wim's option would be the first thing I would do. You could either constrain the found set to just that record or go to related record using a 1 to 1 relationship. If you really wanted to lock it down you can create a custom menu that excludes commands that would allow them to see other records ( Show All, Find Mode, Go To Next, etc ).
yea Win has this one right.. where "It goes to another LAYOUT to view the PDF" go to a layout where the PDF record is isolated
Go To Related record will not isolate only one record, at least when I use it.
So, I suggest something like this
Set Variable $record to your records id such as the uuid field.
perform find for recordIDfield= $record
got to your pdf layout
Hide Toolbar/status bar lock (not needed really since there is only one record, however, the user might do a show all, right?)
add a close window button
The problem is not just showin all of the related records rather than one but also preventing the user from selecting show all.
If you isolate only the one record without creating a new window, you can't return to your layout with the portal and its found set, reliably... The new window reliably returns to your found set and the particular record when it closes.
Go To Related record will isolate one record if there is a 1 to 1 relationship to another table occurrence of the same table and "Match Current Record Only" is selected.
Apart from the record isolation techniques suggest by others, instead of simply going to another layout, you could also go to that layout in a new window and make that window modal. This has a couple of advantages:
1. You do not affect any of the settings in the original window, because you have isolated a single record in a new window
2. Because the window is modal the user cannot do anything outside of that window while it is active
3. You can control everything the user can do in that window via scripts, custom menu, etc
4. If that window has isolated a single record then that's all they can see there if you have it all locked down
You could achieve a similar thing by placing the PDF view on a popover button.
Best trick I learned when isolating the current record:
- New Window
- Show All
- Omit record
- Show Omitted Only
- Print / Save As PDF
An alternative now available to the three-step:
- Show All
- Omit record
- Show Omitted Only
is the one-step:
Find matching record << use the PK field >>
Sounds like a dance lesson!
I've never heard of a one to one relationship in FileMaker. FileMaker Help
lists single criteria relationships which may be what you mean.
A portal shows one to many related records.
The portal lists many related records. Using Go To Related record and
selecting match current record only takes me to that record but the other
related records are in that found set which is the problem being mentioned
in the thread.
Match current record in my cases finds 8 of 200 records. Match all related
records shows me all records related to all records in my current found set.
FileMaker does not show just the one related record clicked on in the
portal even though the radio button implies this is what happens.
Again, this is the problem of the question.
Be careful about using Show Omitted Only in multi-user environment.
When a new record is created by another user just before you do Show Omitted Only, you'll end up with a found set of two records instead of one.
The most reliable approach is to use Find Matching Record or Perform Find or Constrain Found Set or GTRR (Go To Related Recordds) based on the record's unique ID (aka primary key).
If you use GTRR you can even include the New Window in that one script step.
Sometimes Show All also has impact on performance especially when accessing your solution from WAN and dealing with a table containing a lot of records.
To disable scroll wheel record navigation:
Use the script step "Show/Hide Toolbars," specify the Hide option, and tick the Lock checkbox.
A one-to-one relationship is supported in FileMaker solutions but it is really a special form of a one-to-many where, by design, there will be one and only one related record. This would be the case if you set up a self relationship between two table occurrences of the same table using the primary key on both ends. You could then use this relationship with a GTRR to isolate the current record.
I am unable to find *Find Matching Record in the help. Is this one of your
plugin script steps?*
It is a standard script step in the Found Sets group.