Importing records to repeating field

[Ritche M]

How do i import multiple records from Table A into a single record but with repeating fields in Table B. The result will be one record on Table B with repeating fields, the same number with what was imported. The repeating fields of Table B is similar to the fields of Table A.

Thanks in advance

[Søren Dyhr]

Well you don't!!! Save repeating fields for relationkeys and containerfields, that is as a utility. You must come up with a very good reason why you can't let the tables relate via the relationships ...I could come you with a solution ...but honestly is reaching out for repeating fields a bad habit think of 1NF...

--sd

[Ritche M]

Yes, i know that it's a bad habit to use repeating fields but i only inherited this solution and it has many records and with many relationships with other tables.

[Søren Dyhr]

Well this one is crossing the river to fetch water, but make yourself a small template main and a portal of data +the dreaded repeater ...stuff both the first coloumn of the portal with data and the repeater with the same data. Startup Script Editor (applescript) and compare the two corresponding fields... no wait a minute I upload the template I made to make my mind straight...

--sd

ForMacsOnly.zip

[transpower]

Store each incoming field into a global; then set each repetition of the repeating field to its corresponding global.

[Ritche M]

Thanks very much S