G
Guest
I'm creating a form to organize enginering drawings. The "drawing number",
"title", and "station name" are stored in one table. I've also created a
table that lists all the "station names" and their corresponding "ID"s. I'd
like for the program to look at every entry in the field "station name" on
the 1st table, refer to the 2nd table to find the matching number, and then
automatically enter the "ID" number in a new field on the first table.
Is this possible? What level of experience with Access is necessary to
complete this task? Thank you very much for your help!
"title", and "station name" are stored in one table. I've also created a
table that lists all the "station names" and their corresponding "ID"s. I'd
like for the program to look at every entry in the field "station name" on
the 1st table, refer to the 2nd table to find the matching number, and then
automatically enter the "ID" number in a new field on the first table.
Is this possible? What level of experience with Access is necessary to
complete this task? Thank you very much for your help!