[muglo] Re: FMP 3.0

Hi Martin

Thanks for your help and I used the first method which worked fine for 
a part of the file.  Unfortunately some of the records are scattered 
about the file.  I tried to import a second group but I found that this 
wiped out the first lot - I was hoping that the second batch would 
merge in but no!!  Is there a way of copying a second group or does it 
have to be all done in one group? Or could one create a number of files 
and then merge them?  If so how can one merge them?

Paul

On Jun 19, 2005, at 11:34 PM, Martin Albinger wrote:

>
> 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/
>
>

_________________________________________________

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: