S
susanhull
I'm creating a data entry form using a query: AgencyID from my main
table and AgencyID (primary) and AgencyName from the related Agency
table. I want the user to select from a drop down list of agency names
from the Agency table. When the record is added to the main table, how
do I update the AgencyID on the main table, instead of the AgencyName
on the Agency table?
Your suggestions how to accomplish this would be appreciated. I'm
relatively new to Access.
table and AgencyID (primary) and AgencyName from the related Agency
table. I want the user to select from a drop down list of agency names
from the Agency table. When the record is added to the main table, how
do I update the AgencyID on the main table, instead of the AgencyName
on the Agency table?
Your suggestions how to accomplish this would be appreciated. I'm
relatively new to Access.