Creation record via multi-criteria relationship

[Pavel Smirnov]

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)

[eos]

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.

[Pavel Smirnov]

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.

[eos]

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.

[Pavel Smirnov]

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

[Lee Smith]

Automatic message

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