Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Lemur21
  • Content: Threads
  • Order by date
  1. Lemur21

    Calculation Fields referring to previous record

    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...
  2. Lemur21

    Modification Dates

    Hello, I have - a series of join files for interrelated databases (using FM 5.5). Here's the situation. One of the fields is an 'average' which averages all the occurences that meet a certain criteria (specifically, the person's name and the game name). Consequently, all the occurences for...
  3. Lemur21

    Speeding up Calculation Fields

    Hello, I have a slew of calculation fields in one of my files. However, 90% of them are calculations of related fields, and -- as far as I know -- they cannot be indexed. Consequently, the page loads VERY slowly. Is there any other way in Filemaker 5.5 to make speed up the calculation field...
  4. Lemur21

    Go to Related Record

    I had thought I'd understood this, but it appears it won't do what I want this to do. Let's say I have two files - Players and Games, there's a join table called PlayerGames. I have a portal in Players that lists all the games that player has played; and a portal in Games that lists all the...
  5. Lemur21

    Speeding up calculations

    Hello, I'm working on finalizing my database -- I've come a long way! Regrettably, the wall I've recently hit is a pretty big one. A lot of my calculations in one file take AGONIZINGLY long to compute. I even tried to store them, but I'm unable to do so. Does anyone have any ideas about how...
  6. Lemur21

    Help with Subsummaries (I believe)

    I need some help with subtotaling information in portals – let me explain specifically: I have a file called “Players” and another called “Games.” There also another file called “Sessions” – there are join files for PlayerSessionJoin and GameSessionJoin. Essentially, on portals in sessions...
  7. Lemur21

    Can values be 'ranked?'

    Assuming that I have a record with a portal. In the portal are values from 5 users -- their names and their scores (which means, 5 record in the join table). Is there a way to have the values RANKED - i.e., I'd like to have another field; calculation, I assume, that would 'rank' the values in...
  8. Lemur21

    Begging for help on understanding relationships...

    Sigh...I feel like I've been through the wringer! I am using FM Pro 5.5 -- have been trying to get my head around this for a while, and I'm really just beaten down I am essentially converting over a massive (40mb) Excel spreadsheet into database form. This database contains all the information...
  9. Lemur21

    Better questions re: FM - need help with relations (?)

    I’m in the process of converting over a large (40mb) Excel spreadsheet into a FM database. This is the data for my boardgaming group and all related stats. I found – online – this program (http://www.goldraven.com/GameTracker/GT.html). However (1) it hasn’t been updated in 3-5 years; (2) it’s...
  10. Lemur21

    Few questions re: FMP 5.5 - ranking & Countif

    Hello, It's been a few years since I've used Filemaker -- I've been doing a lot more work in Excel...Nonetheless, I have a couple of questions as I convert my spreadsheet into a database... 1. Is there any way, within filemaker, to 'rank' results in fields (especially repeating fields). For...

Part and Inventory Search

Back
Top