Hi everyone. I'm new to the Forum and to Filemaker. I have a question regarding my database. I have created a database that is used to track scores at rifle matches. There are two events, the individual matches and the team matches (not all the individuals shoot on a team). I've done a pretty good job of setting up the individual portion of the database but I'm having trouble with the team portion.

The team part of the database needs group team members (if they are on a team it is listed in the indidual layout), pull their scores from the individual layout, total each team score, and sort the teams in descending order. It also needs to ignore shooters from the individual layout that are not on a team. FYI, everything is viewed in table view.

Could someone at least point me in the right direction of how would be the best way to go about this?

Thanks!

Dan

what you want is to create a portal, traditional a portal would be on a individuals record (i use portal to track magazines sent to a individual)

but a solution is easy enough to work in reverse

create a team datebase which contains basic team information like name and anything NOT dependent on individuals. then use a portal to sort all individuals with the same TeamID

Now all you have to do is make sure you set the same TeamID in the individual records and link

Individuals>TeamID to Teams>TeamID in the relationship graph.

File maker will do the rest.

Thanks! So the Team database should be a separate filemaker database file then? I assume the TeamID could just be the name of the team?

Same FILE but a different database, a single FM file can have multiple databases

the TEAMID should be limited to something that wont change and isn't complex (ie spaces and special characters) this is best performed by using a auto enter Serial number in your TEAM Database

it's then a simple matter of usingthe same ID in the individuals

if you want the individual records to show the TEAM NAME when your printing the file just make sure in the layout the teamID isn't visable and you reference TEAMS name it will look something like

:Team Name

or

TEAMS::Team Name in the field box

But worry about all the pretty stuff later

Create your Team Database and go from there first

Thanks for your help. I'll give it a try!

Hi LLX-

Well, I've been trying to get it to work for some time and I'm a bit stumped. I setup the Team table with TeamID and Team Name and set the relationship with my other table.

My problem is when I setup the portal, I want it to display the team name, the 4 shooters names on that team with their individual score, and then the total team score (the sum of of the 4 shooters individual scores). Then I want the teams to sort in descending order.

I'm not sure what I'm doing wrong. I think I'm close though. I've attached the Filemaker file. Do you think you could take a quick look and tell what I'm doing wrong?

I really appreciate your help, I realize I'm just a stranger on the web, but you've been very helpful

-Dan

Foliage_Match.zip

cant really look at the file atm but lets cover the basics

the portal

I want it to display the team name

>>this is easy enough enough, if you get the team Database ID to load in the portal just change it to load the TEam Name field

the 4 shooters names on that team with their individual score,

>> your portal should be a sort of the individuals DB so it sould lod for each record a list of individuals matching team id

Ugg. I'm still not getting it to work. I'd be happy to reimburse you for your time to take a look at the file.

Foliage_Match.fp7.zip

I am afraid it needs more than a look. It's not only that your relationship is set up incorrectly (it should use ONLY the ID fields). A much more serious problem is that you are missing an entire table of Results. You won't get very far by entering the results into individual fields in the participants table.

At the very least, you should have tables for Participants, Teams and Results, related as:

Teams -< Participants:

Teams::TeamID = Participants::TeamID

Participants -< Results:

Participants::ParticipantID = Results::ParticipantID

This is the minimum needed for a single event (with multiple results). If you want to record more than one event, you'll need to add a table of Events and relate each result to a specific event. And if not all participants are competing in all events, you'll need another table for registrations.