Create multiple records II

[Joop Siroop]

Hi, I'm new here and working with Filemaker 5.5

I'm trying to generate records based on two tables.

Every combination of fields in the 2 tables should be generated.

Another thread suggested something like:

Set Field [ Counter; 0 ]

Loop

Duplicate Record/Request

Set Field [ Counter; Counter + 1 ]

Exit Loop If [ Counter = 200 ]

End Loop

...I invented something like this (I'm a beginner) but my script doesn't stop.

I would appreciate any help.

Thanx a lot.

[aaa]

If field "Counter" is not global make it as a global.

Edited July 25, 2005 by Guest

[Joop Siroop]

Thanx for you quick answer.

How do I make the field counter global in FM5.5?

Edited July 25, 2005 by Guest

[aaa]

File/Define fields/Click on "Counter"/Choos Global/Click Save/Ok/Choos Number

Edited July 25, 2005 by Guest

[Joop Siroop]

OK, found that...made it global but the script does not stop.

Here is my script: (I printed to file with CutePDF writer and copied)

Go to Layout [ Layout #1 ]

Go to Record/Request/Page

[ Last ]

Set Field [ counter, 0 ]

Loop

New Record/Request

Insert Calculated Result [ link_id, link_id = link_id +1 ]

[ Select entire contents ]

Set Field [ counter, counter = counter + 1 ]

Exit Loop If [ counter >= 10 ]

End Loop

Exit Script

What do I do wrong? (a lot probably)

[aaa]

Instead Set Field [ counter, counter = counter + 1 ]

Wright Set Field [ counter, counter + 1

Do this for:

Insert Calculated Result [ link_id, link_id = link_id +1 ] too.

[Joop Siroop]

You're great, thanks a lot.

The reason I'm making this is the following.

I have 2 tables:

- var-1 (about 15.000 but let's say 2 values)

- var-2 (let's say 3 values)

I want to auto-generate records with a calculated text field like:

record 1="var-1= 1" "var-2= 1" bla bla bla

record 2="var-1= 1" "var-2= 2" bla bla bla

record 3="var-1= 2" "var-2= 1" bla bla bla

record 4="var-1= 2" "var-2= 2" bla bla bla

record 5="var-1= 3" "var-2= 1" bla bla bla

record 6="var-1= 3" "var-2= 2" bla bla bla

Then I need to export the calculated textfields of each record that is called value_var1-value_var2.txt

Is this possible in FM5?

Edited July 25, 2005 by Guest