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 (AT) yahoo (DOT) com> wrote:

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*am, c... (AT) tele2 (DOT) ch (Christoph Kaufmann) wrote:
Sorting the relationship by check number and using Last() would be
much faster I believe.

DJ

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

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 )