New to FM, Stuck in a Relationship

[Jason Hefley]

Well I am as entry level as you can get using Filemaker, I have done some online training for the program and it has been helpful, but I am stuck.

 

I think I understand the parent to children relationship, and its importance but I have run into a bind.

 

The database I am trying to put together is for Fantasy Basketball.  My goal is to import the available players for the day, get their stats, and provide a report on the available players for the day.

 

I have one table of all the active NBA players.  The field are: Player Names, Team, Web address to their Stat Page.

 

The second table is a list of all players that are playing today, with the fields: Player Name, Position, Salary, Fantasy Points AVG. 

 

The first table is just a list of all the players.  The second list changes daily with the schedule of games being played that day.   I am trying to run a report that uses the second table, list the players available available today, and gives a link to their page found in the first table.   

 

Eventually I want to be scraping web sites for data, doing calculations, and providing reports based on these calculations/data.  The first step (I think) is to link the stat page to the actual players playing that day.  I still have a lot to learn about scripting, and all the other tools I am going to need to do this.

 

I appreciate any help you can give me

 

Stuck in Seattle,

 

Jason

 

 

[dansmith65]

I think I understand what you are trying to do, but what part are you stuck on?

 

You'll probably want to relate your two tables by Player Name, which will allow you to get the web address of a player from a layout based on the second table.

[Jason Hefley]

That is what I tried to do, then I tried to run a report to display the Player Names available from the second table, and list fields from the first table