Search results for query: *

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

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

LOL - I'd love to say I understood what you were referring to Here's the basic structure. Database A is a join file between Databases B and C, with several calculations. Then, Database B sums up the records in Database A - based on similar records using a id field, and reports them onto...

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

Hi Jean, Won't that, however, only take me to the join file? I need to get to the OTHER file... Chris

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

Striker.. Actually, I was able to save the fields as auto-entered calcs, which can be indexed. Basically, within each record, I only need the calc done once -- when the record is first created. The problem was, in another file, there's a consistent re-checking of those records, for 'totals'...

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

Hi Striker, Well, it helps in that I know what I can't do now ;) What suggestions would you have for how I could display the info I have in the portals on the other files' layout, that I'd be able to see in browse mode? Damn! I was convinced I'd figured it out! :/ Chris

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

Actually, I *was* able to do this with a calculation - albeit a fairly lengthy one. In my related field, where I had "score", I then added three more fields - Score2, Score3 and Score4. I created a field in the portal file, for Max_Score, which I could find easily, as well as new fields for...

In your example, I'd want it to do: Rank Value 1 500 2 400 2 400 4 200 5 100 I'm okay with using a script - basically, there could be a button that would say "assign ranking." The important thing is that, after that script is run, there HAS to be a # in the rank...

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

Jean, I don't think you'd understood my question - yes, while it would be great to understand the goldraven application, even a blanket diagram/understanding of how to set something like that up at ALL was all I needed -- it could've been students taking classes at a university. While the...

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

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

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