Hi all,

I'm quite new at FileMaker, and I've been having some trouble getting it to do something which is really simple, but which I can't figure out.

I've been asked by a friend who runs a charity (a free language school for kids in Slovakia) to do a small database for him. All is OK, except he wants the kids attending this school to be attributed a separate number, which looks like this : ABCC, where A is 1 to 9, according to the year they first attended, B is either 0 or 5 (1st or 2nd semester), CC is 01 to 99 and is the individual kid's number. Don't ask me why, but he wants to keep this system, as he says it's clear to him. So 1521 means it's the 21st person to attend in the second semester of the 1st year of the school's existence.

Anyway, when a new kid joins a class, I need FM to look up the last number in the "Number" field, and just add a 1, with the possibility of modifying that number when a new school year or semester starts.

I don't know if I'm very clear here, and I suppose I could go on searching, but it's 7 am, and I want to go to sleep.

If any of you can help out, I'd be most grateful.

Rob

You can create new field Number which is calculation=Right(ABCC,2) which returns number.Then Summary field Max_Number which is Max(Number), so your new kid`s number will be Max_Number+1 in the foundset of records for current year and current semester. This is the one of the ways. There is many ways to do this.

aaa,

Thanks fot the tip. Using your advice and a little bit of imagination, I managed to get the result I was looking for.