Access 2010 basic question - table update from form
Posted on 2014-11-02
Noobe to Access, so this is very basic, so be gentle! I think it should be simple.
Database with multiple tables. One we'll call master and has multiple fields and thousands of records. Other tables have from a few dozen to a few hundred records in a single field to be used as selection lists for data input. Form set up to use combo boxes to the small tables to create the selection lists during data entry. I want the data to all be saved to the appropriate fields in the master table. I can create a new record OK and save it, and all the manually input fields work, but the fields retrieved using the selection lists from the other tables don't update the master table. Gotta be something basic I'm missing, so any help appreciated. thx