FM10
I have a CHEQUE LOG for US and Cdn cheque books. I want to insert two
boxes in the header of a table layout that will show the last US and
the last Cdn cheque number so that when I create a new record (cheque
record) I know the next number. In my setup US cheques are numbered
US0001 etc. and Cdn, CD0001 etc.. Any suggests or ideas on how to best
do this?

Thanks
Matthew

Buckbuck <buck.matthew74@yahoo.com> wrote:

> FM10
> I have a CHEQUE LOG for US and Cdn cheque books. I want to insert two
> boxes in the header of a table layout that will show the last US and
> the last Cdn cheque number so that when I create a new record (cheque
> record) I know the next number. In my setup US cheques are numbered
> US0001 etc. and Cdn, CD0001 etc.. Any suggests or ideas on how to best
> do this?

What I do here:
create indexable number field or number result calc fields that hold
only the numbers of the ID (0001 instead of CD0001).

Same with a text field or text result calc field for US and CD.

Create a TO of the same table, joining the present records type (US or
CD) with itself (match: all US for a US, all CD for a CD).

Use the max function to determi the highest number of the related
records.

-- 
http://clk.ch

On Mar 23, 4:34=A0am, c...@tele2.ch (Christoph Kaufmann) wrote:
> Buckbuck <buck.matthe...@yahoo.com> wrote:
> > FM10
> > I have a CHEQUE LOG for US and Cdn cheque books. I want to insert two
> > boxes in the header of a table layout that will show the last US and
> > the last Cdn cheque number so that when I create a new record (cheque
> > record) I know the next number. In my setup US cheques are numbered
> > US0001 etc. and Cdn, CD0001 etc.. Any suggests or ideas on how to best
> > do this?
>
> What I do here:
> create indexable number field or number result calc fields that hold
> only the numbers of the ID (0001 instead of CD0001).
>
> Same with a text field or text result calc field for US and CD.
>
> Create a TO of the same table, joining the present records type (US or
> CD) with itself (match: all US for a US, all CD for a CD).
>
> Use the max function to determi the highest number of the related
> records.
>
> --http://clk.ch

Sorting the relationship by check number and using Last() would be
much faster I believe.

DJ

In article
<e4db7077-6b1e-46d9-88ea-1b4cf2845a47@f36g2000pri.googlegroups.com>, David
Jondreau <david@wingforward.net> wrote:

> On Mar 23, 4:34=A0am, c...@tele2.ch (Christoph Kaufmann) wrote:
> > Buckbuck <buck.matthe...@yahoo.com> wrote:
> > > FM10
> > > I have a CHEQUE LOG for US and Cdn cheque books. I want to insert two
> > > boxes in the header of a table layout that will show the last US and
> > > the last Cdn cheque number so that when I create a new record (cheque
> > > record) I know the next number. In my setup US cheques are numbered
> > > US0001 etc. and Cdn, CD0001 etc.. Any suggests or ideas on how to best
> > > do this?
> >
> > What I do here:
> > create indexable number field or number result calc fields that hold
> > only the numbers of the ID (0001 instead of CD0001).
> >
> > Same with a text field or text result calc field for US and CD.
> >
> > Create a TO of the same table, joining the present records type (US or
> > CD) with itself (match: all US for a US, all CD for a CD).
> >
> > Use the max function to determi the highest number of the related
> > records.
> 
> Sorting the relationship by check number and using Last() would be
> much faster I believe.

Sort the Relationship in reverse order and then just use the field name
via the Relationship.
i.e.
         Relationship::ChequeNumber

FileMaker automatically uses the data in first related record, which in
reverse sort order will be the highest number.

Helpful Harry  :o)