I have a Database for my billiards league. I have a MatchT linked to TeamStatsT. Each match has 2 records in the TeamStatsT. Each TeamStats record is designated Home or away (True/False)
I am trying to design a Form that looks like this:

Date Home Team Visiting Team
Edit 9/14/2010 Concords verses Shooters
Edit 9/14/2010 Sharks verses Critters
Edit 9/14/2010 Breakers verses Devils
Edit 9/14/2010 Gangsters verses Vipers

I plan to click on Edit to bring up the MatchDetailF for editing or deleting, or click on the team name to bring up the TeamDetailF.

My problem is to show a Match record with 2 teamStats sub records on the same line??