Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About RichPizor

  • Rank
  1. RichPizor

    Total Newbie Question

    Okay, so...it's possible that i can't even do what I'm trying to do or that this isn't the appropriate way to do it, but some help would be appreciated. I play a game called HeroClix. One of the things you need to do in this game is assemble armies of little figures within certain constraints. So my goal is to create a database with two primary functions: cataloging my particular collection of figures and their relevant statistics, and then using that list to compose armies. So my thinking was to create two databases, one for each primary function, and use relationships between the two of them to accomplish the goal. So far I haven't been able to get it to work. Ideally I'd like a record in the army creation section of the database to have, say, a dozen pop-up lists. Each list would reflect the figures entered into your collection, and figures selected in one list would be removed from the other lists. (ie if i have Captain Marvel and Spiderman, and i select Spiderman in list A, list B contains only Captain Marvel.) Selecting a figure in any of these lists would then update a running tally of how many points you've spent, and how many you have remaining against a user-entered total. Is this even possible? If it is, how do I go about it? I tried creating a relationship between the entry database and the army building database, but I have thus far been unable to find a way to get the information to show up in the form of a list (or, indeed, at all). Any help is greatly appreciated. As far as my own experience, I've created a number of stand-alone databases but am essentially a virgin when it comes to relationships. Thanks!

Important Information

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