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. 

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

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.