thanks for your reply! but i still hava a question,my database :
League: LeagueID, LeagueName
Team: TeamID, TeamName, LeagueID
Game: GameID, GameDate, TeamID_A, TeamID_B, Goals
Odds: OID,Home,Draw,Away,GameID,CID
BettingCompany:CID,CName
I use DBMAN SQL 2.1 ,when I add data of Odds, How can I have two input menu(input name TeamID_A,input name TeamID_B) automatically generated from table Game.Like:Liverpool v Leeds so what shall I do?thks!
League: LeagueID, LeagueName
Team: TeamID, TeamName, LeagueID
Game: GameID, GameDate, TeamID_A, TeamID_B, Goals
Odds: OID,Home,Draw,Away,GameID,CID
BettingCompany:CID,CName
I use DBMAN SQL 2.1 ,when I add data of Odds, How can I have two input menu(input name TeamID_A,input name TeamID_B) automatically generated from table Game.Like:Liverpool v Leeds so what shall I do?thks!