Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!swrinde!elroy.jpl.nasa.gov!usc!jarthur!ucivax!gateway
From: cmacfarl@trocadero.ICS.UCI.EDU
Newsgroups: comp.sys.mac.apps
Subject: Relational files in 4D
Message-ID: <9102141103.aa17479@PARIS.ICS.UCI.EDU>
Date: 14 Feb 91 19:08:14 GMT
Lines: 18

I would like to know if it is possible to do the following:

I have set up a relational database such that you have a People
file and a Company file.  With a many to one relation between
[People]Company and [Company]CompanyName.  This allows you to relate
many people in the People file to one company in the Company file.

My question is, is there any way to change the name of a company in the
Company file and have that change reflected automatically in all the people
in the People file?

For example, if I have a database with a company called XYZ and many people
related to that company and the company changes its name to ABC then how
does the People file get updated to correspond with the changed name in
the Company file?

Many thanks,
Craig