dbTalk Databases Forums  

Going to Specific Record in Preview Mode

comp.databases.filemaker comp.databases.filemaker


Discuss Going to Specific Record in Preview Mode in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Adam Sugerman
 
Posts: n/a

Default Going to Specific Record in Preview Mode - 11-01-2005 , 06:15 PM






Hello -

This is FMP 7.03 running on FM Server for both PC and Macs.

I have a database with printable layouts that run one to three pages,
depending on how much information is in the records being printed.
When a user clicks the "print" button, it brings them to a dialog that
allows them to print just the record being browsed or all records in
the current found count. They can also preview what the printout will
look like or just print it.

The problem is that if they want to preview the current record, and if
that record isn't the first in the current found count, previewing will
take them to the entire found count and they'll be confused about why
they're seeing all records despite the fact they clicked "this record
only." Of course, when the layout is actually printed, stored
preferences will print only the one record, but this won't save them
from the aforementioned confusion.

It appears that since I can't anticipate how many pages each record
will require (and this what record to navigate to in Preview mode), the
only way to guarantee they'll see just the one record is to omit all
other records in the found count when choose "this record only." Easy
enough, but then they've messed up the set of records they were
viewing, which can be equally confusing. This is a networked database
with multiple users and thousands of records, so I'm not a big fan of
trying to mark found sets for recovery at the end of a script.

Is there a solution to this? Does FMP provide a way to go to a
specific record by ID or relationship in Preview mode? Any suggestions
would be greatly appreciated.

Best,
-S.


Reply With Quote
  #2  
Old   
FP
 
Posts: n/a

Default Re: Going to Specific Record in Preview Mode - 11-01-2005 , 10:08 PM






If the user wants to preview just this record you could open the report
in a new window and do the show all, omit, show omitted thing.


Reply With Quote
  #3  
Old   
Adam Sugerman
 
Posts: n/a

Default Re: Going to Specific Record in Preview Mode - 11-02-2005 , 03:18 PM



Brilliant. I haven't made use of the new window step in my solutions,
so this didn't occur to me. A great solution. Thanks for your help.

-S.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.