TLM

Well seems it's a bit more 'complex' than i initially explained (i had to split up the Results_PointScales tables in two -> Scales and Scales_Points), sorry about that. Here is an image of a part of the database with the significant tables. So the 'flow' would go like this; - Results is the table where information is entered, like Year, Date, Category, Startplace, Finishplace, Distance, Racing Time, ... for a particulair race. - Results_Placings is where the names of the riders are entered who placed themselves in a race with the following information, Place, riders name (retrieved from another table), Time behind winner, Points received for this particular race, ... So if a particular finishes as 2nd in a race of category GO then he needs to receive the points as such as they are in the Scales and Scales_Points tables. Don't know if i need the Points field (u_placings_Points in the image) in the Results_Placings file, guess it could be solved with 'multi-predicate' relationships like CobaltSky said. But i will probably need more than one and that's were i'm stuck for the moment Hope this is clear enough, to understand what i want to retrieve. TLM Version: v7.x Platform: Mac OS X Panther

Just playing with a trial version of FileMaker Pro 7 and i got a question. For a solution i made for myself (in-house so to speak i have three tables like this with the relevant fields; Results (ID, Category) Results_Placings (Results_ID, Place, Points) Results_PointScales (Category, Place, Points) In earlier version i needed some multi-field keys to lookup a value in Results_Placings::Points based on the Results::Category and Results_PointScales::Place values. It should be possible (i guess) to solve this in FMP7 with relations but i seem to be unable to accomplish this. Wrapping my brain around the new relational scheme of FMP 7 seems to be hard this evening. Does anyone have some pointers/solution for me i can use to work on Thanks in advance TLM Version: v7.x Platform: Mac OS X Panther