Welcome to your Green Bay Packers Online Community!

Since 2006, PackersHome has been providing a unique experience for fans.
Your participation is greatly anticipated!
Login or Register.
Go to last post Go to first unread
Offline Wade  
#1 Posted : Sunday, December 23, 2012 2:17:02 PM(UTC)

Rank: All Pro

Joined: 8/1/2009(UTC)
Location: nowhere of importance

Applause Given: 667
Applause Received: 671

Ok, it's time I started mooching off you people and your superior tech and/or logic skills. Or at least get help in uncluttering the disarray that is my mind whenever I try to set up any database.

Here's the situation. I'm trying to create a database for my current chip inventory and any future acquisitions/sales. I'm using the full-featured version of FIlemaker Pro 12 ("Advanced").

In particular I want to classify my chips three overlapping ways and have the database automatically assign each a serial number that contains all three dimensions of classification. The three dimensions are:

1. Chips that are part of one or more "game sets" being assembled vs. chips that are purchased as individual chips. For example, I recently bought 80 $1 "Bud Jones CIC" chips from the Stardust casino to be part of a game set called "Mixed casino BJ #1". I also bought, from a different seller one $5 Stardust chip which will not be part of a game set.

1A. Chips purchased to be part of a game set are sometimes purchased in a group (as in those 80 $1 Stardusts) or individually (I've purchased another 10-15 of that same $1 Stardust, each one at a time.

2. Chips are part of a special collection vs. chips that are not. For example, Both the 80 $1 chips and the one $5 chip are part of a collection named "Stardust." On the other hand, a $100 chip from the Playboy Atlantic City is not a part of any special collection.

3. Chips that are part of multiple special collections. For example those $1 Stardusts are not only part of the "Stardust" collection but also part of a collection called "$1 Vegas".

These are not the only fields by any means, but what I'd like to do is create a unique serial number that (i) reflects all three pieces of information and (ii) automatically adds 1 to that serial number every time I add something else.

For example, one of my special collections is made up of all chips I own that have the "Small Key" mold. So suppose the last two records I entered into the database were (i) a set of 200 $25 chips from the Ponce de Leon casino which will be part of that "Small Key" collection AND part of a game set called "Mixed casino Small Key" AND part of a game set called "Ponce de Leon", and (ii) an individual small key chip from the Sky Harbor casino. (i) was entered using a serial number GS2-SKey-121, and (ii) was entered using a serial number IN-SKEY-092.

Now what I want to happen is to be able open the data entry form for adding to the collection, and upon clicking one or two radio buttons ("Part of game set" and "Individual chip"), and checking checkbox(es) for each collection the chip will be a part of, the database will automatically enter the serial number. So, for example, regardless of how many chips have been entered in between, the next individual small key chip will get entered as IN-SKEY-093.

So my question is this: Can I do this, and if so, how?

(These three dimensions do not exhaust the information that is entered when a record is added to the database, but they are the ones that I would hope to have reflected in my "Wade Serial Number" field.


Wade The CheapAss Mooch.
And do not be conformed to this world, but be transformed by the renewing of your mind, that you may prove what is that good and acceptable and perfect will of God.
Romans 12:2 (NKJV)
Rss Feed 
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.




Recent Topics
1m / Green Bay Packers Talk / StarrMax1

20m / Green Bay Packers Talk / PackFanWithTwins

24m / Green Bay Packers Talk / PackFanWithTwins

31m / Green Bay Packers Talk / Mucky Tundra

42m / Green Bay Packers Talk / PackFanWithTwins

47m / Green Bay Packers Talk / PackFanWithTwins

2h / Green Bay Packers Talk / buckeyepackfan

2h / Random Babble / Wade

2h / Green Bay Packers Talk / Wade

2h / Around The NFL / Pack93z

4h / Random Babble / Pack93z

4h / Green Bay Packers Talk / Pack93z

5h / Random Babble / Pack93z

5h / Welcome to our Community! / Zero2Cool

5h / Green Bay Packers Talk / FLORIDA PACKER88

Copyright © 2006-2014 PackersHome.com™. All Rights Reserved.