Hi,
I am trying to create a form in Datasheet view thay will allow me to look up a name based on a corresponding player number in a table.
I want to be able to put the players Number in a field, and have the adjacent field come up with the name.
I have the following info in a table called Players..
PlayerID Surname Forename Shirt Number
1 Travers Darren 88
2 kent James 66
3 James Chris 69
4 White Craig 44
5 Darkins Holly 29
6 Crane Dave 4
7 Nockalls Dave 20
8 Miller Matt 99
9 Warwick Kath 6
10 Letheren Ian 9
I'm eventually looking to use this as a subform on a mainform
Anyone help me get my Ice Hockey databas moving !?! :D :D :->
I am trying to create a form in Datasheet view thay will allow me to look up a name based on a corresponding player number in a table.
I want to be able to put the players Number in a field, and have the adjacent field come up with the name.
I have the following info in a table called Players..
PlayerID Surname Forename Shirt Number
1 Travers Darren 88
2 kent James 66
3 James Chris 69
4 White Craig 44
5 Darkins Holly 29
6 Crane Dave 4
7 Nockalls Dave 20
8 Miller Matt 99
9 Warwick Kath 6
10 Letheren Ian 9
I'm eventually looking to use this as a subform on a mainform
Anyone help me get my Ice Hockey databas moving !?! :D :D :->