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

Groups > comp.databases.filemaker > #2222

Re: Changing to a Different Related Record

Show all headers | View raw

Helpful Harry <HelpfulHarry@BusyWorking.com> wrote:

> 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.

I'm not following this time, Harry. In my case, there's just a simple,
one-field, linkage between related records. Suppose I have a very small
business which has led me to make the foolish mistake of linking orders
to customers through the customers' last names. The behavior I'm seeing
is that when I try to change to a different related record by typing a
different last name over the original last name, FMP is changing the
last name of the original related record.

As with accounts receivable, the relationship is many-to-one.

Charlie
-- 
Nobody in this country got rich on his own.  You built a factory--good.
But you moved your goods on roads we all paid for.  You hired workers we
all paid to educate. So keep a big hunk of the money from your factory.
But take a hunk and pay it forward.  Elizabeth Warren (paraphrased)

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