Hi gurus and experts

I have a question that im trying to solve with little to no luck.

I want to be able to search my database to grab all the data based on a specific team in my hockey league. More specifically, what Id like to do is this:

If you are viewing the stats for team ABC, Id like for it to go to the table and layout of the league schedule, and pull out the data for that team (both home and away games) automatically, without my having to hard code the names of the team in.

I have a relationship between the teams and the schedule, so you wouldnt think this would be so hard, but its driving me batty. Right now, I just have a code that grabs the data for one team hardcoded as a script, but id love to do this for all 16 teams by using a variable.

Any suggestions on how to even get this started would be greatly appreciated, Im not expecting anyone to do it for me, but just some pointers or points in the right direction would be great.

Thanks for reading.

Brian

If its related, why not just use a go to related record step instead of a find?

Good question/suggestion Mr_Vodka

I went out today and bought 2 new Filemaker books, and spent the day reading on how to do things.

Your suggestion seems really simple, i'll have to try it.

Thanks