Automatic entries

  • Thread starter Thread starter Guest
  • Start date Start date
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!
 
From your description of your form and what you are trying to do, I will
assume that you are entering the "drawing number", the "title" and the
"Station Name". If this is the case and what you want to do is to store the
Sataion ID from your second table, then you could just a combo box to your
form. Have the combo box to display the contents of the second table. Then
when you want to enter the Station Name you would be able to simply select it
from the combo box and not have to enter it again. If the combo box is set up
correctly, using the second table, it can display the list of valid stations
names but actually store the ID for the selected Station.

This is not as difficult as it may sound. Just take a look in the Help file
for "Combo box" and you should be able to get started.

If you need more assisgance, just post back here and someone will be happy
to try to assist.
 
Back
Top