Path: utzoo!utgpu!news-server.csri.toronto.edu!bonnie.concordia.ca!clyde.concordia.ca!nstn.ns.ca!news.cs.indiana.edu!att!linac!pacific.mps.ohio-state.edu!zaphod.mps.ohio-state.edu!ub!dsinc!netnews.upenn.edu!eniac.seas.upenn.edu!alex From: alex@eniac.seas.upenn.edu (Edmund Davis) Newsgroups: comp.sys.mac.apps Subject: Re: Relational files in 4D Message-ID: <37592@netnews.upenn.edu> Date: 15 Feb 91 00:49:52 GMT References: <9102141103.aa17479@PARIS.ICS.UCI.EDU> Sender: news@netnews.upenn.edu Reply-To: alex@eniac.seas.upenn.edu (Edmund Davis) Organization: University of Pennsylvania Lines: 21 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) that's it. alex ---- Edmund A. Davis Internet: alex@eniac.seas.upenn.edu ACIUS Registered Developer US Mail: 233-F So. Melville St. Philadelphia, PA 19139 (215) 386-3305