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


Groups > comp.databases.filemaker > #2220

Re: Changing to a Different Related Record

From Helpful Harry <HelpfulHarry@BusyWorking.com>
Newsgroups comp.databases.filemaker
Subject Re: Changing to a Different Related Record
Date 2015-04-20 09:02 +1200
Organization Aioe.org NNTP Server
Message-ID <200420150902143828%HelpfulHarry@BusyWorking.com> (permalink)
References <1m34ji3.pa6vtn1i5vevhN%csampson@inetworld.net>

Show all headers | View raw


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)

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


Thread

Changing to a Different Related Record csampson@inetworld.net (Charles H. Sampson) - 2015-04-19 11:58 -0700
  Re: Changing to a Different Related Record Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-04-20 09:02 +1200
    Re: Changing to a Different Related Record csampson@inetworld.net (Charles H. Sampson) - 2015-04-20 23:14 -0700
      Re: Changing to a Different Related Record Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-04-21 18:42 +1200
        Re: Changing to a Different Related Record csampson@inetworld.net (Charles H. Sampson) - 2015-04-21 13:25 -0700

csiph-web