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

Groups > comp.databases.filemaker > #945

Re: Auto Enter Scheme

Show all headers | View raw

Since your New Customer ID is never going to change I don't see any reason 
to use an Auto Entered Value. Use a normal calculation instead.

ursus


"bilbod"  schreef in bericht 
news:4f504aac-ace5-450a-86db-48303cce73da@googlegroups.com...

Hi Harry,

Thanks so much for looking at this issue. Evidently you've had your own 
struggles with auto-enter. I did set up a field with your calculation and, 
so far, won't populate the field.

The match field for a Vehicle on creation by ::invoice file is Vehicle ID in 
the Vehicle file, right side of relationship. We're after the ::customer ID 
which is already in ::Invoices, wanting Vehicle to auto enter that in its 
own Customer ID. So
Customer ID Auto Enters by Calculation as below

Case(

Vehicle ID = "", "", Invoice::New Customer ID

)

Is this what you were suggesting?

Best regards,
Bill

On Wednesday, August 1, 2012 7:29:35 PM UTC-6, Helpful Harry wrote:
> In article <0e976e29-a65c-4a38-961f-01594ce5fa7a@googlegroups.com>, bilbod
>
> <bjaynes@montanaport.net> wrote:
>
> >
>
> > Hello,                                  FM5 Windows XP
>
> > A relationship Invoices::Vehicles allows record creation; uses a number
>
> > for a match field.
>
> >
>
> > When a new instance of Vehicle is created as above, I would like to have
>
> > vehicle record auto enter data from a field in the Invoices file using a
>
> > Vehicles::Invoices relationship that uses the same match fields. So far
>
> > it won't work, I suspect because of evaluation order.
>
>
>
> There's an option to only evaluate Auto-enter calculations when the
>
> referenced fields are not empty ... but it tends to be a bit flakey, so I
>
> enforce it within the calculation.
>
>
>
> Instead of the Field's auto-enter calucation being something like:
>
>
>
>      = Invoices:VehicleField
>
>
>
> change it to be:
>
>
>
>      = If (MatchField = "", "", Invoices:VehicleField)
>
>
>
> That way the auto-enter calculation remains empty until there is data in
>
> the MatchField (and hopefully then a valid Relationship link) before
>
> retrieving the VehicleFIeld data.
>
>
>
> Helpful Harry  :o)

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

Thread

Auto Enter Scheme bilbod <bjaynes@montanaport.net> - 2012-08-01 10:47 -0700
  Re: Auto Enter Scheme HelpfulHarry@BusyWorking.com (Helpful Harry) - 2012-08-02 13:29 +1200
    Re: Auto Enter Scheme bilbod <bjaynes@montanaport.net> - 2012-08-07 09:07 -0700
      Re: Auto Enter Scheme "E. Appeldoorn" <ursus.kirk@ziggo.nl> - 2012-08-07 18:18 +0200
        Re: Auto Enter Scheme bilbod <bjaynes@montanaport.net> - 2012-08-07 10:37 -0700
      Re: Auto Enter Scheme HelpfulHarry@BusyWorking.com (Helpful Harry) - 2012-08-08 18:31 +1200
  Re: Auto Enter Scheme "E. Appeldoorn" <ursus.kirk@ziggo.nl> - 2012-08-02 09:10 +0200
    Re: Auto Enter Scheme HelpfulHarry@BusyWorking.com (Helpful Harry) - 2012-08-02 19:33 +1200

csiph-web