[muglo] Re: FMP 3.0

On 19-Jun-05, at 10:39 PM, Paul Thomas wrote:

> I have a large file of nearly 1800 records in FMP 3.0.   I wish to make
> a new file of about 25 of these records.  Can anyone tell me if there
> is an easy of doing this?  I can obviously make a duplicate and delete
> most of them one-by-one, but that's tedious? I can't see a way of doing
> a block delete other than the entire file.  Alternatively, can I create
> a new file and copy over some of the records and if so how?
>
> Any help please would be appreciated.
>
There are a number of different approaches.  If the file structure is 
the same you could create a clone with no records (Under save As).  
Rename the file.  If you can identify easily the 25 records you want to 
keep do a find for them.  Once the records are isolated as the found 
set you can close the file (not necessary but visually less cluttered). 
  Open the clone file (which you renamed) and File: Import Records from 
the original database. Since the clone is a copy of the original you 
can use Matching Field Names and everything should just import in.

If this is more complicated than you need let me know.

FMP does allow block deletes.  When you tell it to delete records you 
have a choice of the record you are in or the *found set*.  If the 
found set is everything other than the 25 records you want you will end 
up with just those 25 records after telling FMP to delete all.

Put another way Delete All deletes just the found set.

Does that help?

Martin

_________________________________________________

For information concerning the MUGLO List just click on

           http://muglo.on.ca/Pages/joinus.html

Our Archives can be viewed at 

         http://www.freelists.org/archives/muglo

Don't forget to periodically check our web site at:

                 http://muglo.on.ca/

Other related posts: