Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #1994

Re: Filemaker - sorting

Show key headers only | View raw

In article <89ec3722-5afd-4f2a-8a25-80fe64981d82@googlegroups.com>,
ihp98230 <viking.1943@hotmail.com> wrote:

> I have several hundred different data base files in Filemaker format. I would
> like to merge many of them so I am down to only a handful of large files but
> still retain the ability to work within any one of them when that is more
> convenient. 
> 
> I am contemplating establishing a new field in each file, and merge all of
> the old files into this larger file. However I would still like to retain the
> old file names but as a field heading so if I want to look up one specific
> section I can still do so quickly and easily. 
> 
> It is easy to add an additional field to every Filemaker file, the question
> is how can I do that quickly when there will be nothing in that field
> initially. Some files can have thousands of individual records but i cannot
> find any way to create a new field and then put the same thing in each of
> those records quickly and easily. Doing it one file at a time could easily
> take days simply using copy and paste, but doing it 50,000 times. 
> 
> Does anyone know a quick and easy way to do this?
> 
> Any help would be appreciated.

Probably the safest and easiest way is to initially make the new field
as Calculation field that is set to be whatever text you want.
i.e.
     NewField    Calculation, Text Result
       = "FileName"

where Filename is really whatever the name of the file is.

Click out of all the Define Fields windows and FileMaker will create
the new field with that data. Then go back into the Define Field window
and change the NewField to be an ordinary Text field - it will retain
the calculated data.


Helpful Harry   :o)

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Filemaker - sorting ihp98230 <viking.1943@hotmail.com> - 2015-02-18 14:41 -0800
  Re: Filemaker - sorting Ursus <ursus.kirk@ziggo.nl> - 2015-02-19 00:03 +0100
    Re: Filemaker - sorting ihp98230 <viking.1943@hotmail.com> - 2015-02-18 15:29 -0800
      Re: Filemaker - sorting Ursus <ursus.kirk@ziggo.nl> - 2015-02-19 00:51 +0100
        Re: Filemaker - sorting ihp98230 <viking.1943@hotmail.com> - 2015-02-18 17:25 -0800
          Re: Filemaker - sorting dempson@actrix.gen.nz (David Empson) - 2015-02-19 16:08 +1300
            Re: Filemaker - sorting ihp98230 <viking.1943@hotmail.com> - 2015-02-18 19:38 -0800
              Re: Filemaker - sorting dempson@actrix.gen.nz (David Empson) - 2015-02-19 17:25 +1300
                Re: Filemaker - sorting Ursus <ursus.kirk@ziggo.nl> - 2015-02-19 09:59 +0100
                Re: Filemaker - sorting viking.1943@hotmail.com - 2015-02-22 06:00 -0800
                Re: Filemaker - sorting Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-02-23 08:54 +1300
  Re: Filemaker - sorting Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-02-19 13:16 +1300
    Re: Filemaker - sorting John G <john.g@green.com> - 2015-02-23 11:01 +1100
      Re: Filemaker - sorting Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-02-23 16:38 +1300
        Re: Filemaker - sorting John G <john.g@green.com> - 2015-02-23 15:39 +1100
          Re: Filemaker - sorting viking.1943@hotmail.com - 2015-02-23 19:25 -0800

csiph-web