Recent content by weedot

I have a table that holds data thus Hometeam Awayteam Weekno Date teamA teamB 1 teamC teamD 1 teamE teamF 2 teamG teamH 2 teamJ teamK 3 The problem I have is allocating a date for each weekno ie both...

ahh two nations seperated by a common language!!!!!! I shall try to Americanize this for you. Your American football consists of AFC and NFC- call these 'sections'. Each team in these 'sections' play against each other at least once a season- call these fixtures. The resource could be a...

Hope someone can help me out here! I have a table that holds a fixture list for various competitions. The teams are split into, normally, no more than 2 sections. Each section would then play in one of 2 sessions. A 'bye' team is added to even up the fixtures if required. My problem is that...

Thank you Thanks GTH. Made some changes based on your advice and form is working a treat now.

This probably exists elswhere on the forum but cant find itso any help will be great. Want to select a list of players from the players table who arent in a selected team for a selected competition. For example there are x number of females in the players table, and as each is entered in a...