FMP 8 Adv: I have a text field and a number field that require
auto-enter. They need to be data fields, no way to use calc.

The text field has auto-entry lookup. I get the correct value as soon as
I create the DS resp. have data up in the fields on the left side of the
relation.

The value of the number field is an auto-enter lookup, too, but the
above mentioned text field is on the left side of the relation I use.

As soon as I put data in the text field, the auto-enter of the number
field works. However, the number field remains empty when I create a new
record, althouth the text field has received its value. I need to refill
the text field in order to trigger the auto-enter of the number field.

I have tried auto-entry lookup and auto-entry calculation, evaluate and
If ( 1 oder text field) both, but no joy.

Seems there's no other way than to script it?


--
http://clk.ch

In article <1ju0b46.12czud41fbxjo4N%clk (AT) tele2 (DOT) ch>, clk (AT) tele2 (DOT) ch (Christoph
Kaufmann) wrote:

There's a bit of a "bug" in the processing of auto-enter options.

You can try playing with the "do not evaluate" / "don't copy" options for
when the field(s) are blank, but that may not make any difference.

The best way I've found to achieve a working result for auto-enter
calculations is to test for empty Fields myself.
e.g.
NumberField Auto-enter by calculation
= If (
(NeededField1 = "") or (NeededField2 = "") or ...;
"";
NeededField1 & NeededField2 & ...
)

Basically you have to test to see if any of the required Fields are emtpy.
If they are then leave the auto-enter Field empty as well, otherwise
perform the calculation. FileMaker seems to see the empty auto-enter Field
as "unprocessed" and calculates properly once all the required Fields have
their data.

BUT, in newer versions of FileMaker your problem could be cause by the
rather silly "feature" of not committing data properly, and therefore not
creating the Relationship link. In this case the only way to achieve what
you want will be to Script the process making sure to Commit the record's
data. (

Helpful Harry )

Helpful Harry wrote:

Great! It works with FMP 10 and gets me a correct value in the number
field.

It doesn't work for a second number fields that depends on a calc that
depends on the first number field, but that's another story :-)

--
http://clk.ch

"Christoph Kaufmann" <clk (AT) tele2 (DOT) ch> wrote

For this one you can try setting the Calculation Field's options to not
calculate if the referenced Fields are empty ... but again it's flakey and
best to do it yourself by changing the Calculation Field to something like:

CalculationField
= If (FirstNumberField = "";
"" ;
{whatever the calculation is}
)

Make sure this one is set to be Not Stored.

Then the second number Field can use the previously posted auto-enter
calculation.
i.e.
SecondNumberField Auto-enter by calculation
= If (CalculationFieldField = "";
"" ;
{whatever the calculation is}
)

You may need to "Or" test for other empty Fields in that first line of both
If calculations - you need to test all the Fields used within the
Calculation.

Helpful Harry )