Path: utzoo!mnetor!tmsoft!torsqnt!news-server.csri.toronto.edu!cs.utexas.edu!swrinde!zaphod.mps.ohio-state.edu!tut.cis.ohio-state.edu!wolfman.cis.ohio-state.edu!francis
From: francis@wolfman.cis.ohio-state.edu (RD Francis)
Newsgroups: comp.sys.mac.apps
Subject: Re: Relational files in 4D
Message-ID: <FRANCIS.91Feb15113318@wolfman.cis.ohio-state.edu>
Date: 15 Feb 91 16:33:18 GMT
References: <9102141103.aa17479@PARIS.ICS.UCI.EDU> <37592@netnews.upenn.edu>
Sender: news@tut.cis.ohio-state.edu
Organization: Ohio State Computer Science
Lines: 17
In-reply-to: alex@eniac.seas.upenn.edu's message of 15 Feb 91 00:49:52 GMT

In article <37592@netnews.upenn.edu> alex@eniac.seas.upenn.edu (Edmund Davis) writes:
   There is no automatic function for updating the many file when the related
   one-field changes.  You must write a script more-or-less as follows:

   (Place it in the [Company]CompanyName field and set the Only if Modified flag)

   relate many([Company]CompanyName)
   $new:=[Company]CompanyName
   apply to selection([People];[People]Company := $new)

Along the more or less lines, it's important to note that (unless it's
one of the things that got changed with version 2.0) local variables
($<varname>) don't carry their definitions into APPLY TO SELECTION
commands; try replacing $new above w/ NewCoName or something like
that, to get better results.
--
R David Francis   francis@cis.ohio-state.edu