Join Our Green Bay Packers Interactive Community!

We have been providing fans with the best source of Packers information since 2006!
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: 670
Applause Received: 675

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)
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.

Powered by YAF.NET | YAF.NET © 2003-2014, Yet Another Forum.NET
This page was generated in 0.248 seconds.




Recent Topics
20m / Random Babble / musccy

29m / Green Bay Packers Talk / Gilligan

33m / Random Babble / Smokey

1h / Random Babble / yooperfan

6h / Welcome to our Community! / Smokey

6h / Around The NFL / Smokey

7h / Super Bowl Talk / Smokey

7h / Green Bay Packers Talk / uffda udfa

8h / Random Babble / Cheesey

9h / Green Bay Packers Talk / DarkaneRules

9h / Random Babble / texaspackerbacker

15h / Green Bay Packers Talk / uffda udfa

19h / Green Bay Packers Talk / DoddPower

22h / Green Bay Packers Talk / steveishere

23h / Green Bay Packers Talk / Mucky Tundra

Copyright © 2006-2014™. All Rights Reserved.