Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Lemur

  • Rank
  1. Hello, I have a portal that currently shows all related records (as it should). Sometimes, however, I'd like it to only display certain records. Every record in my related file has a field called "active" - this displays whether the player is active or not (with a "Yes" or "No"). I would like to create a button that - when pressing it - will only display those players listed as "active" in the portal. I can then have another button that will reverse this (i.e., do the default - show all). What would be the easiest way for me to set up this "find?" -- I can then throw it in
  2. I was able to solve this problem. As I mentioned, I needed to denote the most *recent* record in the file. Once I did that, and changed the relationship to search by that field, instead, I was able to get the proper information to show up. Thanks to all who helped! Chris
  3. Hi Michael, I now know why it's not working, but I've no idea how to fix it. Let me go into more detail (and step away from the easier-to-understand "calorie" scenario, and discuss what it's really doing). The database tracks scores in various games played. Each game has it's own id#, and then, each person has his own id# (and name). So, to see game1 / Bob, the id/name field would be 1Bob. In addition, for the FIRST time someone has played a game, there's an X-Field (which denotes their first playing). So, someone playing game 1 for the first time would have X1 with their record
  4. Hello, I have a database that handles a slew of "running totals" (for argument's sake, call it 'calories consumed'). Let's assume, in this database I have 8 people listed, and I have all their calories for each meal during a week (21 in total). If I want to have a portal that shows each of the 8 people, with the total calories consumed (i.e., the total from the most recent record), *sorted* in descending order of total calories - how would I be able to do that? When I set up a typical portal, it seems to pull the data from the first record in the database; not the most recent (w
  5. Hi, Yes, I saw that one too...it's pretty close. The problem is it relies on serial number (which is fine). And, then, each record has a 'previous serial number) which is the current serial number -1. In my case, there may be hundreds of serial numbers before the same 'game id' comes back. Chris
  6. Hi, Yes, this is very nearly what I want. There's only one difference -- I'm not looking to create a running tally of ALL the records...just the ones that are 'related.' Take a look at the sample file (which I've updated a bit from the first post). You can see in Record 1, that "Bob" playing game #1, started with a rating of 5000, and added 100 points. Bob shows up again in Record 5, but playing a different game (game id #2) - again, he starts with a rating of 5000 and loses 33 points. His final time is in Record 9, playing game #1 again. What I NEED is for the "Base R
  7. Hello, I'm trying to determine the best way to set up a running calculation that uses previous records as the base. Imagine, for example, 4 players play a game for the first time. The base score all players start with is 5000. During that game, Player 1 gains 100, Player 2 gains 50, Player 3 loses 50 and Player 4 loses 100. The NEXT time they play the game, I would like their base scores to reflect the changes from the last game (so, new scores would be 5100, 5050, 4950, 4900), and so on. I've been able to set up relationships within the file to allow the 5000 to be pl
  8. And, in other words, it will always pull from the most recent? always? I can definitely set up a script to sort by date upon closing the table -- that will ensure the newest is the most recent.... Chris
  9. Hi Vich & Fitch, I already have them in separate tables - in fact, the whole 'database' is 9 tables, with 3 join files. I know I can get it to work - the hard part is telling it to pull the MOST recent base value to work from. How would you do that? i.e., assume the following example: Game 1: Base value 5000, gain 33, new base value 5033 Game 2: Base value 5033, gain 50, new base value 5085 Game 3: Base value 5085, lose 25, new base value 5060 How do I ensure that the Game 4 base value is 5060? I can do a relationship in the table, but how can I direct it to pu
  10. Whew...let me see if I can explain this properly, and then, see if it's even possible. I'm looking to set up a running calculation for my boardgaming group. One formula basically compares the scores of the various players, and determines how much each player will win or lose. That total affects the previous "base" total, and a new base total is generated. So, for example, let's assume all 4 players start the game, tied at 5000. They're playing Monopoly. At the end of the game, the formula determines that the 3 losing players should lose 33 points each, and the winner should gain thos
  11. Ah!! Yes... So, what's happening is NOT that it's noticing that, for example, that calculation field is changing -- it's saying, 'hey, since one of these records changed, we'll select ALL the records that have that same identifier (i.e., 350Chris). OK - that's a good workaround - it's not checking for what I THOUGHT it needed to check; but it's accomplishing EXACTLY the same thing. Very cool..... Chris
  12. Yes! Yes! Yes! That does work -- to test it, I set the clock on the computer ahead, and adjusted some sample records...worked great. Can you explain how it works? I'm still a little lost on that - why does it know the modification date (even though it doesn't change) is changed for those fields that are calculation only? Thanks again! Chris
  13. Hi John, I saw you had your email addy listed in your profile; so I did zip up all the files and sent them to you... (be forewarned, in the playerplayedjoin file (the one I sent you earlier) the bottom two fields in creation order serve no purpose currently - I'm trying to figure this out, and those were my 'test' fields). Chris
  14. Hi John, Actually, I didn't forget to reattach -- I just posted simultaneously In any event - I can't reattach them all - the total is over the 1mb limit the site allows. But, you don't actually need the other files (I don't think) - if you do the steps I mentioned, I'm 99% sure the information will all be in that one file I sent you. It'll probably give you some error messages, because they are all relatable; but, essentially, the other files have no bearing on what I'm trying to accomplish here. Chris
  15. Thanks John... I've been going nuts today trying to figure out an easy fix -- seems like it should be fairly easy; but I guess I'm wrong Chris
  • Create New...

Important Information

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