Serial Numbers Based on Date

[Booker]

Hi all,

New to filemaker and have (what seems like) a simple question. How do I make a field that numbers the entries for the day. I have multiple transactions everyday and need them to be numbered 1-X everyday.

For example my fields are:

Date, Client name, Item name, Price, Multiplier, and Daily transaction #.

I am using Filemaker 10 and Mac os X

thanks for the help,

Booker

Edited September 22, 2009 by Guest

[LaurenKuhlman]

So, you want to restart your page numbering each day like this

Orders for Today:

1-092209

2-092209

3-092209

Orders tomorrow:

1-092309

2-092309

You'll need a self-relationship or to control it via script. I will build a sample file with a self-relationship...

I would have to agree that this particular scenario is not safe in a multi-user environment. When necessary, it requires baby-sitting and of course should never be used as a primary key.

SerialNumbersBasedonDate.fp7.zip

Edited September 24, 2009 by Guest

[Søren Dyhr]

Could you make a plausible explanation why this scheme should be safe in a multi user environment?

--sd

[Vaughan]

To follow-on from Soren, such numbering can be done, but it's generally never a good idea. Nothing but trouble. Always ends in tears.

Whatever you do, don't use these numbers for relationships or anything important. Use auto-entered serials for relationship primary keys.

[comment]

I agree - see also:

http://fmforums.com/forum/showtopic.php?tid/211171/post/340744/#340744