Update Table from Form

[Danyl Werntz]

I have created a form to input data and would like a
couple of fields to "automatically" enter lengthy
descriptions from "master file" type tables. I have
relationships set as one-to-many from two master files to
the table which should be filled in by data entry in the
form.

I can't seem to figure out how to get this to work like I
want. I've tried two things:

1) Created a form using only the 'Data Entry Output' table
to select fields and attempted to change the properties
of 'control source' and 'default value' for the
two "automatic description" fields, in order to fill in
description data directly from the 'Master File' tables.
I tried various SELECT statements and expressions to no
avail. When I enter the key field values into the form
(relationships set one-to-many from both 'Master File'
tables to 'Data Entry Output' table), the corresponding
descriptions are either blank or give me an error message
#Name?.

2) Created a form using BOTH the 'Data Entry Output' table
AND 'Master File' table to initially select fields for the
form. I selected the two "automatic description" fields
from the two 'Master File' tables and selected all the
rest of the fields from the 'Data Entry Output' table.
When I enter the key field values in the form, the
description DOES come up in the form, but DOES NOT update
the 'Data Entry Output' table with those "automatic
descriptions" (all other fields get updated to the 'Data
Entry Output' table properly). In other words, the data
in the form is all complete, but the table it is to update
is partially incomplete.

Any advice on how to accomplish this? It seems to me like
this should be an extremely straight-forward task, and I
am probably overlooking something really simple.

Thanks,
Danyl Werntz