Wade
  • Wade
  • Veteran Member Topic Starter
11 years ago
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.

Thanks.

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)
Fan Shout
dfosterf (3h) : The only problem with that is he isn't a guard either.
dfosterf (4h) : Put him at right guard. That is where he will be coached. That is where he will compete. He is not even allowed to look at the LT playbook.
dfosterf (19h) : Kidding aside, I hope the best for him.
dfosterf (19h) : Went to a Titans board. One comment there. Not very long. I quote: "LOL" They don't sound overly upset about our aquisition.
beast (20h) : OT Dillard has been absolutely horrible... like OG Newman levels
dfosterf (20h) : Suit him up and have him stand in front of the big board as a draft day cautionary tale.
Zero2Cool (21h) : Packers sign T Andre Dillard.
Mucky Tundra (18-Apr) : Adds most of the information this time of year comes from agents.
Mucky Tundra (18-Apr) : @RealAlexBarth Bill Belichick says accurate draft information doesn't leak from teams until about 12 hours before the draft. Adds most of th
Mucky Tundra (18-Apr) : I am very happy that for moment, Jordan Love seems like a normal human being
Zero2Cool (17-Apr) : Belichick * whatever
Zero2Cool (17-Apr) : "There's a lot of depth at Offensive Tackle and Wide Receiver." Bill Bellichick
Zero2Cool (17-Apr) : Thanks! I can't believe it's over haha
Martha Careful (16-Apr) : Congratulations
Zero2Cool (16-Apr) : Boom. Student Loan. $0.00. Only took about 20 years.
Zero2Cool (14-Apr) : Packers DT Kenny Clark: New defensive coordinator Jeff Hafley will 'allow us to be way more disruptive'
Zero2Cool (12-Apr) : Saints have agreed to terms on a contract with former Packers wide receiver Equanimeous St. Brown.
beast (12-Apr) : No, but of it's for legislation, then half of the country will find it evil, not good, whatever it says....
Mucky Tundra (12-Apr) : Draft is still 2 weeks away. UGH
dhazer (11-Apr) : Does anyone know of a good AI generator to create letters of Support for legislation?
Zero2Cool (11-Apr) : Gordon "Red" Batty retires as equipment manager
Zero2Cool (10-Apr) : Sounds like that's pretty certain now.
Zero2Cool (10-Apr) : Packers "at" Eagles in Brazil. Week One
dfosterf (10-Apr) : Va' Fazer As Malas Va' !
Zero2Cool (9-Apr) : Mark Murphy tipping us off?
Zero2Cool (9-Apr) : “We’re either the first- or second-most popular team in Brazil.”
Zero2Cool (9-Apr) : Christian Watson got married. Wife better be careful with those hamstrings!! 😂😂
dfosterf (9-Apr) : Those poor bastards
Zero2Cool (8-Apr) : Falcons have signed former Packers CB Kevin King, who has been out of football since 2021.
dfosterf (8-Apr) : Collectively, we need to spend more time in what we have, when analyzing ostendible needs and historical proclivities
dfosterf (8-Apr) : I say he is better than so many of these draft picks
dfosterf (8-Apr) : Question of the week for me: Has anyone besides me done any deep dive into the potential of Alex McGough, our 3rd string qb?
Zero2Cool (8-Apr) : Or in Tunsil's case, something gets released day of draft or day before lol
Zero2Cool (8-Apr) : Seems every year someone does something pre-draft.
dfosterf (8-Apr) : Falling down drunk. The draft board
dfosterf (8-Apr) : Allright! Potential character guy/f#×k up pickup in D'Vondre Sweat!
Zero2Cool (7-Apr) : Go Badgers!!!
Martha Careful (6-Apr) : Go Boilermakers!!!
Martha Careful (5-Apr) : Diggs has not stepped up in the playoffs and has a high cost
beast (5-Apr) : Probably not going to let Diggs walk away unless he's horrible... but according to reports he also might not be as good as he used to be.
beast (5-Apr) : The 25th pick in the draft has been an offensive player since 2017, 2 TE, 2 WR, 1 RB, 1 OC
Mucky Tundra (5-Apr) : Odd, why give up a 2025 2nd Rounder for him if you're just gonna let him walk?
Zero2Cool (4-Apr) : Texans to let Diggs be free agent in '25
buckeyepackfan (4-Apr) : 49r's aign RB Patrick Taylor.
Martha Careful (4-Apr) : Reversion to the mean would indicate we will keep it
Zero2Cool (4-Apr) : It's also been utilized in a trade in 14 of the past 20 years
Zero2Cool (4-Apr) : The 25th pick in the draft hasn't been made by it's original holder since 2016.
Mucky Tundra (4-Apr) : Gotta imagine that Green Bay vs Houston will be a primetime game this upcoming season
Zero2Cool (3-Apr) : No. Kill QB. No worries. 😁
Mucky Tundra (3-Apr) : Diggs, Collins, Dell and Schultz is gonna be tough to cover
Please sign in to use Fan Shout
2023 Packers Schedule
Sunday, Sep 10 @ 3:25 PM
Bears
Sunday, Sep 17 @ 12:00 PM
Falcons
Sunday, Sep 24 @ 12:00 PM
SAINTS
Thursday, Sep 28 @ 7:15 PM
LIONS
Monday, Oct 9 @ 7:15 PM
Raiders
Sunday, Oct 22 @ 3:25 PM
Broncos
Sunday, Oct 29 @ 12:00 PM
VIKINGS
Sunday, Nov 5 @ 12:00 PM
RAMS
Sunday, Nov 12 @ 12:00 PM
Steelers
Sunday, Nov 19 @ 12:00 PM
CHARGERS
Thursday, Nov 23 @ 11:30 AM
Lions
Sunday, Dec 3 @ 7:20 PM
CHIEFS
Monday, Dec 11 @ 7:15 PM
Giants
Sunday, Dec 17 @ 12:00 PM
BUCCANEERS
Sunday, Dec 24 @ 12:00 PM
Panthers
Sunday, Dec 31 @ 7:20 PM
Vikings
Sunday, Jan 7 @ 3:25 PM
BEARS
Sunday, Jan 14 @ 3:30 PM
Cowboys
Saturday, Jan 20 @ 7:15 PM
49ers
Recent Topics
4h / Green Bay Packers Talk / dfosterf

13h / Green Bay Packers Talk / Mucky Tundra

17h / Random Babble / Zero2Cool

18-Apr / Green Bay Packers Talk / Zero2Cool

18-Apr / Random Babble / Mucky Tundra

18-Apr / Green Bay Packers Talk / Mucky Tundra

17-Apr / Green Bay Packers Talk / Mucky Tundra

17-Apr / Green Bay Packers Talk / Mucky Tundra

17-Apr / Green Bay Packers Talk / beast

17-Apr / Green Bay Packers Talk / beast

17-Apr / Green Bay Packers Talk / beast

16-Apr / Random Babble / Martha Careful

15-Apr / Green Bay Packers Talk / dfosterf

12-Apr / Random Babble / Nonstopdrivel

12-Apr / Green Bay Packers Talk / Martha Careful

Headlines
Copyright © 2006 - 2024 PackersHome.com™. All Rights Reserved.