Hi,

Seriously Stuck!

Basically I'm helping a friend out by producing a nice little database for his guitar shop. The Guitar Shop gives each item in the shop a separate serial number, at the moment they give these out manually but i wish to change that using filemaker.

In short i was wondering if any one new how to allocate an "auto enter" serial number to different categories. e.g. For all Electric Guitars the serial has the letters GE in-front of it. This makes the serial read GE1234. now the problem I'm having is allowing that to raise by 1 and then also allowing another category e.g. AC to raise by one independently from GE but keeping them in the same field.

By the end of it i want each item to be allocated a unique serial number. The serial must include the Category code and it's individual number (only individual to that category).

Any answers would be much appreciated.

Cheers

elliot

Edited September 14, 200619 yr by Guest

Keep in mind that you should use an internal serial number for any actual relationships you build in the database. You can then always build a field that shows your client what they're used to seeing (without it actually doing anything substantial behind the scenes).

A recent similar discussion took place in:

http://fmforums.com/forum/showtopic.php?tid/180106

You can also use a relationship based on product code to generate an auto-entered calculation for a product code.

HTH,

David

Cheers,

The page you liked me to gave me this download:

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

Inside is all the information needed to Serialize by Category (hence the title!)

Cheers for the help

elliot

http://www.larrikinlove.com/media/six_queens.mov http://media.bmgonline.com/rcarecords.com/kings_of_leon/video/king_of_the_rodeo_300_mp4.mov http://media.bmgonline.com/rcarecords.com/kings_of_leon/video/four_kicks_300_mp4.mov http://media.bmgonline.com/rcarecords.com/kings_of_leon/video/the_bucket_300_mp4.mov http://www.makeni.net/Reading2006/bellesebM325k.wmv.asx http://www.makeni.net/Reading2006/pearljamM325k.wmv.asx

Edited September 16, 200619 yr by Guest