automatically fill in related field

  • Thread starter Thread starter Eve
  • Start date Start date
E

Eve

Donna-
Try this - make a new table with 2 columns, Facility Name
and Facility ID. Make a new query with your original
table and the new table. In the query make a relationship
between the two Facility Name fields. Add the Facility ID
field from the NEW QUERY (delete the Facility ID from the
original table if it's in your query). Add the new
Facility ID field to your form, and it should work! Let
me know how it goes.
 
Thanks, but I'm not having any luck. I am really
confused. I have a table with 2 columns Facility Name
and Facility ID. I have created the relationship, but if
I delete the field from the original table, there is no
where to put future data. We are constantly inputting
the same facility names as new records to track calls
made to these facilities. I need to have the original
table's facilities ID field automatically populated when
the Facility name is input into the form linked to the
original table.
 
Back
Top