Help in write a script

[PHP2005]

Hi All,

I have a field called “b_number”, how do I write a scrip asking to find the biggest number at b_number field andafter found I will have the add from the b_number +1 added at b_number.

Any help will be appreciated. Thank you in advance.

;)

[LaRetta]

asking to find the biggest number at b_number field andafter found I will have the add from the b_number +1 added at b_number.

Why not just use an auto-enter serial number? It would save a lot of work. Can you say a bit more about what you are doing and why? What is that b_number?

[PHP2005]

I do have a field with an auto serial number. b_number is to used for a receipt number when people paid in full so each time someone paid I have to print a receipt but it have to be in a serial number.

[comment]

I think you should have a separate table for receipts.

[Fitch]

A couple of ways to solve this:

1. Use a relationship and a calc:

Max(related:_number)+1

2. Or, use a script something like:

Show All

Go to record(last)

Set variable($theBiggest;b_number)

New record

Set field(b_number;$theBiggest+1)

Edited October 15, 2007 by Guest
Why does this forum sometimes break text apart?