ALRIGHT!! Big thank you to LaRetta and comment for solving this problem and everyone lese that tried to help. And again my apologies for the really bad explanation.

Now for the second part of my problem. I tried to present it in another post but an admin merged it with this one.

This is the long version:

I have a database with 100 records. Every record has a number field. I want to fill that field with a random number so I use the following calculation:

Max ( MINIMUM ; Int ( Random * 499 ) + 1 )

To do that I go to "Define Fields", I highlight the number field, I change the type from number to calculation, I press save, a box that says the following:

"When changing the field type to Calculation or Summary, FileMaker will replace any data in the field with the result of the formula. Proceed anyway?"

I press "OK" and the "specify calculation" box appears. I enter:

Max ( MINIMUM ; Int ( Random * 499 ) + 1 )

and press "OK". That takes me back to the "Define Fields" box. I press "done" and then every record has the number field filled by a random number.

BUT what I would like is that when I go to a record and press on the number filled thats when it gets filled AND NOT automatically after pressing "done".

Ender replied this in the other post. Can someone clarify this, maybe show me step by step:

"It sounds like you just need to populate the random number field with a button click? If so, change your field back to a Number and define a script with a Set Field[] script step having your random calc as the source and your field as the target. Then define a button with a Perform Script, selecting your new script as the script to run. "

Edited October 10, 200619 yr by Guest

*bump*

What part was not clear about my solution?

What part was not clear about my solution?

FM is a new program for me. I am a beginner. Could you post a file with an example of what you said please? It is all greek to me at this point.