M
Majeed
Hi.
I have several tables in my sport database. The table "Players" contains the
name of all players. The table "Matches" contains several fields including
the name of "Players". There are 23 fields that contain players name in
"Matches" table, field naming convention is like "P1" , "P2" ..etc
It is cumbersome job to type full players name every time I want to update a
match and of course liable to make a typing error.
I want to create a update form for "Matches" and instead of typing each
players full name , I want to refer to "Players" which has an index. Simply
, instead of typing "Beckham" , I want to select the index number for
"Bekham" which is 432 in "Players" table.
Any help is appreciated.
I have several tables in my sport database. The table "Players" contains the
name of all players. The table "Matches" contains several fields including
the name of "Players". There are 23 fields that contain players name in
"Matches" table, field naming convention is like "P1" , "P2" ..etc
It is cumbersome job to type full players name every time I want to update a
match and of course liable to make a typing error.
I want to create a update form for "Matches" and instead of typing each
players full name , I want to refer to "Players" which has an index. Simply
, instead of typing "Beckham" , I want to select the index number for
"Bekham" which is 432 in "Players" table.
Any help is appreciated.