AnsweredAssumed Answered

Relationship issues (new FM user)

Question asked by nwhawksfan on Apr 11, 2014
Latest reply on Apr 12, 2014 by philmodjunk

Title

Relationship issues (new FM user)

Post

Im in the process of just learning Filemaker, so please bear with me. Everytime I think I have a grasp on the process, I get humbled. So here is the latest:

I am trying to create a report about baseball. My goal is to have a report by position and display all the stats for players that play that position. I have downloaded a .csm file that has every player since 1871 and their associated stats. So here is my thought process.

First I created a table for Position:

Position
pos_name
     pos_id


Next I created a table of players in that postition. I imported these players from a .csm file through the import records: Since I did not care about LF, CF, or RF (instead of), I created a field that if pos was lf, cf, or Rf it would automatically read of.

Player_pos
player_name
     player_nameid
     imported_pos
     pos
     pos_id


Player_nameid, is a derived from a calculation to use the first two initials of a players name combined with his last name to uniquely identify said player

The table positions is the parent and player_pos is the child and a succesful relationship was established.

Now the problem!!!

I created another table to import a players raw stats

stats
player name
player nameidfk
stat_1
stat_2

I was hoping that player_pos could act as a parent (as one player has one position) and the stats table the child (one player has many stats). When I try to establish the relationship I get a many to many relationship, and my macbook almost takes flight in my frustration  

I know that I had a stat column with only the player_nameidfk and entered the data manually using a portal I could do this using an intermediate table. The idea of manually entering literally thousands of lines of data makes me sad. 

What am I missing? I may be just having a fundamental filemaker concept error, so some expert help is appreciated. Thank You

J

Outcomes