How a repeating fields get a value from nonrepeating field

[Omer Faruk EMRE]

Hi, I have two table, ISLEMLER and GENELPARMAKIZI. ISLEMLER::DATE and GENELPARMAKIZI::DATE in relationship and also ISLEMLER::ID and GENELPARMAKIZI::ID, those are sign persons. I have SIRANO field in ISLEMLER table and SIRANO field in GENELPARMAKIZI table. ISLEMLER::DATE and ISLEMLER::SIRANO are repeating fields, but GENELPARMAKIZI::ID, GENELPARMAKIZI::DATE and GENELPARMAKIZI::SIRANO are nonrepeating fields. I want to get value SIRANO field in GENELPARMAKIZI table to SIRANO field in ISLEMLER table in matching record ISLEMLER::DATE and GENELPARMAKIZI::DATE. For example our person's ID is 127 ;

ISLEMLER::DATE[1]=01.06.2015

ISLEMLER::DATE[2]=03.06.2015

ISLEMLER::DATE[3]=05.06.2015

ISLEMLER::DATE[4]=08.06.2015

ISLEMLER::DATE[5]=10.06.2015

ISLEMLER::DATE[6]=12.06.2015

and other table;

GENELPARMAKIZI::ID         GENELPARMAKIZI::DATE            GENELPARMAKIZI::SIRANO

121                                                   01.06.2015                                           123456

121                                                   03.06.2015                                           124489

125                                                   01.06.2015                                           123568

127                                                   01.06.2015                                           123478

127                                                   08.06.2015                                           125569

128                                                   01.06.2015                                           124784

119                                                   04.06.2015                                           125347

I want to get 125569 to ISLEMLER::SIRANO[4]

ISLEMLER::DATE field contains 6 record for person that ID is 127, but GENELPARMAKIZI::DATE field contains 2 record for person that ID is 127.

Can you help me please

Edited June 28, 2015 by Omer Faruk EMRE

[comment]

I want to get 125569 to ISLEMLER::SIRANO[4]

Why [4]? There are only two matching records in the GENELPARMAKIZI table, so if you want to display their values in a repeating calculation field (which I am not sure it's such a good idea), I would expect to get:

ISLEMLER::SIRANO[1] = 123478
ISLEMLER::SIRANO[2] = 125569

and the rest of the repetitions to be empty.

[eos]

Maybe you could try this again, 

1. using table and field names translated into English (which hopefully will clarify what this is about)

2. not using ALLCAPS, and

3. explaining why you are using repeating fields.

And how …

I want to get 125569 to ISLEMLER::SIRANO[4]

… should this happen? The record is #5 in all records, and #2 in a relationship via personID …

[comment]

2. not using ALLCAPS

The post is not using ALLCAPS. The tables and fields names are in upper-case, which I believe is a perfectly legitimate choice.

[eos]

The post is not using ALLCAPS. The tables and fields names are in upper-case, which I believe is a perfectly legitimate choice.

However you want to call it, it makes the post very difficult to read.

[Omer Faruk EMRE]

Thanks. ISLEMLER table contains max 20 repeating fields named DATE and SIRANO. A script get a SIRANO record via web services. For 127. person worked this script and got SIRANO records from SEANS HİZMET KAYIT CEVAP field (a repeating field include xml response )  for 

ISLEMLER::DATE[2]=03.06.2015

ISLEMLER::DATE[3]=05.06.2015, and seem in table.

An another script work for GENELPARMAKIZI table. And got GENELPARMAKIZI::SIRANO records for 01.06.2015 and 08.06.2015 dates.

I used this calculation and it worked for 01.06.2015 but not worked for 08.06.2015

Case( Get(CalculationRepetitionNumber)=1; If( GetValue ( Case ( DATE[1]=GENELDAMARIZI::DATE ; GENELDAMARIZI::SIRA NO ) ; 1)  ≠ "" ; GetValue ( Case ( DATE[1]=GENELDAMARIZI::DATE ; GENELDAMARIZI::SIRA NO ) ; 1 ) ; ExtractData ( SEANS HİZMET KAYIT CEVAP[1] ; "islemSiraNo" ; 1 ))) &

Case( Get(CalculationRepetitionNumber)=2; If( GetValue ( Case ( DATE[2]=GENELDAMARIZI::DATE ; GENELDAMARIZI::SIRA NO ) ; 1)  ≠ "" ; GetValue ( Case ( DATE[2]=GENELDAMARIZI::DATE ; GENELDAMARIZI::SIRA NO ) ; 1 ) ; ExtractData ( SEANS HİZMET KAYIT CEVAP[2] ; "islemSiraNo" ; 1 ))) &

Case( Get(CalculationRepetitionNumber)=3; If( GetValue ( Case ( DATE[3]=GENELDAMARIZI::DATE ; GENELDAMARIZI::SIRA NO ) ; 1)  ≠ "" ; GetValue ( Case ( DATE[3]=GENELDAMARIZI::DATE ; GENELDAMARIZI::SIRA NO ) ; 1 ) ; ExtractData ( SEANS HİZMET KAYIT CEVAP[3] ; "islemSiraNo" ; 1 ))) &

Case( Get(CalculationRepetitionNumber)=4; If( GetValue ( Case ( DATE[4]=GENELDAMARIZI::DATE ; GENELDAMARIZI::SIRA NO ) ; 1)  ≠ "" ; GetValue ( Case ( DATE[4]=GENELDAMARIZI::DATE ; GENELDAMARIZI::SIRA NO ) ; 1 ) ; ExtractData ( SEANS HİZMET KAYIT CEVAP[4] ; "islemSiraNo" ; 1 ))) &

......

 

[comment]

I agree that the post is difficult to read, for several reasons. However, field/table names being in caps is not one of them.

[comment]

I want to get 125569 to ISLEMLER::SIRANO[4]

Why [4]?

Oh, I see: you want to get the value into the corresponding repetition. This can be done through using a lookup - see the attached example.

However, this is not a good method to use - and haven't been so ever since Filemaker went relational in version 3 (almost 20 years ago). Instead of the repeating fields, you should use a join table between the two existing tables, with fields for ID and DATE. Then each record in the join table can simply display the data from corresponding record in GENELPARMAKIZI - without having to copy or calculate anything.

RepeatingLookup.fp7

Edited June 28, 2015 by comment

[Omer Faruk EMRE]

Thanks, it is working.