Hi, everybody,
I am having trouble saving data from two tables in one of them.
My project is a database for tournament registration. Among others, it contains two tables: tblTournament (with the fields "TournamentName" and "TournamentIndex") and tblTeam2Tournament.
On the AddPage of tblTeam2Tournament is a lookup table, where the user picks any value of "TournamentName" from tblTournament.
When the information of the AddPage is saved to tblTeam2Tournament, it saves everything but the "TournamentIndex" of that particular "TournamentName" from tblTournament.
How can I accomplish that?
Thank you in advance,
Wilfried
P.S.: The function "Before Recorded Added" only contains code for sending emails
