Jump to content

Help. Multiple Serials In Multiple Categories??? Using Auto Enter...


This topic is 6465 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 by Guest
Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 by Guest
Link to comment
Share on other sites

This topic is 6465 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.