Seralize By Category

[themooneysuzuki]

Hi,

Trying to get this serialize by category to work but having trouble working out all the calculations etc...

I was pointed to this post http://fmforums.com/forum/showtopic.php?tid/180106 and it links to a document that shows you how to do it but just having trouble importing it and making it work for my set of entries.

Cheers

elliot

Edited October 15, 2006 by Guest
removed ()

[Søren Dyhr]

There is just announced an update to it on JMO's page...

http://www.filemakerpros.com/SerCat7.zip

As you see is the problem with imports in newer versions mentioned, in the intro...

But perhaps you could pinpoint where you can't follow the reasoning behind??

--sd

[themooneysuzuki]

Below are my new tables:

Serial Calc = Case(IsEmpty(First Serial); 1; Previous Serial + 1)

Previous Serial = LookupNext(Serilize by category::Serial Calc; Lower)

First Serial = Lookup(First Serial Number::Serial; "")

Match Category 1 = Category & Right("0000" & (Serial - 1); 6)

Match Category 2 = Category & Right("0000" & GetAsNumber(Serial); 6)

Next Serial = Category & Right((Last Serial + 1); 6)

I think thats all my new calculation in my database but the only problem being it isn't working. I have values in my Match Category that increment by 1 but with a changing prefix (A0001 A0001 B0003 B0004 etc).

Im also getting some weird numbers every now and again. These appear to be random (although I'm sure there not). Any help would be much appreciated. Also if you need any more info please don't hesitate to ask.

Cheers again,

elliot

[themooneysuzuki]

Ok. Sorry about this but kinda a newbie at this so having some trouble. Could you elaborate on whats going wrong and how to fix it.

From what I understand there are a few calculations and look ups going on that:

• Searches for an entries category and then finds the highest value.
• Then takes that value and increases it by 1
• Also if there isn't an exsiting number it replaces it with a 1

Now am i correct or heading totally the wrong way?

Determined to crack this so cheers so far...

elliot

[Søren Dyhr]

Couldn't you upload or send me a clone? I think it's a type mismatch somewhere in the calc'fields.

--sd