Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!1.eu.feeder.erje.net!news.etla.org!aioe.org!.POSTED!not-for-mail
From: Helpful Harry <HelpfulHarry@BusyWorking.com>
Newsgroups: comp.databases.filemaker
Subject: Re: Changing to a Different Related Record
Date: Mon, 20 Apr 2015 09:02:14 +1200
Organization: Aioe.org NNTP Server
Lines: 25
Message-ID: <200420150902143828%HelpfulHarry@BusyWorking.com>
References: <1m34ji3.pa6vtn1i5vevhN%csampson@inetworld.net>
NNTP-Posting-Host: mpBvWBfiYbVLhOMDnCdggQ.user.speranza.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Complaints-To: abuse@aioe.org
User-Agent: Thoth/1.8.4 (Carbon/OS X)
X-Notice: Filtered by postfilter v. 0.8.2
X-Face: vIZzK[X\z-._]-_:U?l@cBtwg<{a>ggn\mH}Vs>38E,#R%7h%U0'=4;1Q=erO %[T#a{YJfGvAbWmE@f_h]<rQ30+q;vqA^FUVx%\9{@r{gt${p^.L~bemFF@WY$r9fhuA F"1)$0+MgN+j8OO<SAec%$P;!M4Aj/kVitK5\xKmed-/3$2LiT1nI!-lKjt0B!qP_E{V ja+\#+[_uq8",IkoIF3M0}}qCD(&
Xref: csiph.com comp.databases.filemaker:2220

In article <1m34ji3.pa6vtn1i5vevhN%csampson@inetworld.net>, Charles H.
Sampson <csampson@inetworld.net> wrote:
> 
> I've got a database in which I can't change to a different related
> record once a record has been committed. Think of accounts receivable
> where you've entered the wrong customer name.
> 
> Whenever I change one of the portal fields, I'm modifying the related
> record instead of changing to a different one.
> 
> I seem to remember doing this before but, if so, I've forgotten how.
> 
> I can create a new record with the related record that I want and then
> delete the record that has the related record that I don't want, but
> that's error-prone and clumsy. I hope there's an easier way.

You would need to change the data in the related record's link field,
which may or may not actually be accessible via the Portal.

Changing the customer name may not automatically change the link
field's data. For example the link field might be auto-entered data
based on the customer name, but either not able or not set to update if
the customer name is changed later.

Helpful Harry  :o)