I've fallen and I cant get up!

[Jason Hefley]

I am trying to create a data base for fantasy football.  I am sure I am not the first nor am I the last.  

 

I am attempting to take all available players at a given site, and calculate value for each player.  I am then going to sort by position to help the selection process each player.

 

I have my tables getting data from a specific excel spreadsheet and importing it into a FM table.   I am then performing calculations to come up with predicted performance.  I next want to take that predicted performance and calculate to "fantasy points per dollar" thus finding the most value.  

 

I have two tables set up as seen in the .jpg.  I can not relate the two tables and I am stuck.  I have tried a join table using position, but no luck.  When I connect to available players, and ESPN predictions using players as my primary key, it results in a many to many relationship and I can do nothing with the results.   

 

In summary I want to create a report that sorts by position, takes data from two tables for each player (salary and proj points) and calculate value.   What join table do I need to accomplish?

 

Thanks.  I hope my lack of understandingof FM does not frustrate the community.  You guys have been awesome in the past.  I am mostly doing this to practice using filemaker. 

[greencanned]

Hey! Were you able to resolve it?  What did you do?

[bcooney]

Jason, although we appreciate your sense of humor, please don't use clever topic titles. Try to describe the issue you're facing in 5 words or less. Use tags.