dbTalk Databases Forums  

Hiding records

comp.databases.filemaker comp.databases.filemaker


Discuss Hiding records in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Steve Bailey
 
Posts: n/a

Default Hiding records - 08-07-2003 , 05:17 PM






I know that you can OMIT records temporarily. But they pop back in as soon
as you SHOW ALL RECORDS or run a script that does so.

Is there a way to hide certain records until you specifically ask them to be
included again, even if you quit and restart?

I have a database of people who have signed up for a workshop. Cancellations
throw off all the counts if they're left in, but I don't want to delete them
since I eventually need them for refunds, etc.

Thanks!

Steve


Reply With Quote
  #2  
Old   
Tim Booth
 
Posts: n/a

Default Re: Hiding records - 08-07-2003 , 06:13 PM








Steve Bailey wrote:
Quote:
I know that you can OMIT records temporarily. But they pop back in as soon
as you SHOW ALL RECORDS or run a script that does so.

Is there a way to hide certain records until you specifically ask them to be
included again, even if you quit and restart?

I have a database of people who have signed up for a workshop. Cancellations
throw off all the counts if they're left in, but I don't want to delete them
since I eventually need them for refunds, etc.
Off the top of my head... I would clone the main database,
and export the records you don't want to that one and delete
them out of the first database.

Cheers

Webko


Reply With Quote
  #3  
Old   
Chris Brown
 
Posts: n/a

Default Re: Hiding records - 08-07-2003 , 09:49 PM



create a Status field (number) and have a script set all your isolated subset
to 1 (1 = OMIT)
easy to deal with the remainder (clearing any others from prior omits....)
if you index Status, you can create a self rel using a global number (1) rel,
for rapid show only related, rather than a find.

Chris Brown
Neurosurgery
University of Adelaide


Steve Bailey wrote:

Quote:
I know that you can OMIT records temporarily. But they pop back in as soon
as you SHOW ALL RECORDS or run a script that does so.

Is there a way to hide certain records until you specifically ask them to be
included again, even if you quit and restart?

I have a database of people who have signed up for a workshop. Cancellations
throw off all the counts if they're left in, but I don't want to delete them
since I eventually need them for refunds, etc.

Thanks!

Steve


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.