Anybody can me explain:

 

two tables has multi-criteria Relationship and Table 1 has  indexed Global match field.

I have a script with a Loop creating new related records, so 1st record will be created, but on second and next will be error 510 (Related record is empty or unavailable)

Please describe exactly what your tables do (no 'Table 1/2') and how your relationships are defined, and post your script code.

 

indexed Global match field.

 

There is no such thing as an indexed global field.

Please describe exactly what your tables do (no 'Table 1/2') and how your relationships are defined, and post your script code.

 

 

There is no such thing as an indexed global field.

 

Table 1                               Table 2

IDT1 (serial number)  =      IDT1

Date Global (global)   =      Date

...                                         ....

 

There are 2 match fields and I allow to create records in Table 2 via Relationship

 

Script in Layout (Table 1)

 

Set Field (Table1::Date Global ; Get (CurrentDate)

Go to Record First

     Loop

          SetField (Table2::Date ; Table1::Date Global)

          Go to Record Next (exit after Last)

    End Loop

 

So will be created only one record  on table 2 related to the first record of Table 1. 2nd and other loops will give 510 error.

This works just fine for me. Most likely your Table 1 records #2 and following don't have a serial number – at least that was the only way I could provoke this error code.

Hah, today works fine for me too. Perhaps I was tired yesterday. Many thanks.

Automatic message

This topic has been moved from "The Left Brain" to "Relationships".