I have a db with fields

student_id (unique serial), names...etc, time_out_id (unique serial), behaviour (with text about the particular behaviour that caused time out), letter_home_number.

In another layout I have a form letter sent to parents that includes the field: letter_home_number.

What I can't work out is how to automate the letter_home_number...ie on first time out the letter number is 1, 2nd time out 2 and so on.

I think I have to make the letter_home_number a calculation-count field but I'm not sure if I'm on the right track...

Or do I need to have another field for each time_out record: number=1...do a find script then count the number or records to insert/merge into the form letter...

Or do I have to make it a sub-summary or summary field...

Or...can I be pointed to a reference

TIA

Stephen K

I have a db with fields

student_id (unique serial), names...etc, time_out_id (unique serial), behaviour (with text about the particular behaviour that caused time out), letter_home_number.

In another layout I have a form letter sent to parents that includes the field: letter_home_number.

What I can't work out is how to automate the letter_home_number...ie on first time out the letter number is 1, 2nd time out 2 and so on.

I think I have to make the letter_home_number a calculation-count field but I'm not sure if I'm on the right track...

Or do I need to have another field for each time_out record: number=1...do a find script then count the number or records to insert/merge into the form letter...

Or do I have to make it a sub-summary or summary field...

Or...can I be pointed to a reference

TIA

Stephen K

You could make a button that runs ascript taking you to the layout for printing the letter_home. Besides going to the layout, the script will increment the letter_home_number as:

Go To Layout (Letter Home)

Set Field [ letter_home_number, letter_home_number + 1]

Every time the letter-home layout is visited (and, presumably, printed & mailed), letter_home_number will go up by one.

Steve Brown

You could make a button that runs ascript taking you to the layout for printing the letter_home. Besides going to the layout, the script will increment the letter_home_number as:

Go To Layout (Letter Home)

Set Field [ letter_home_number, letter_home_number + 1]

Every time the letter-home layout is visited (and, presumably, printed & mailed), letter_home_number will go up by one.

Steve Brown

Thanks

I'll try it

Stephen