Hi,
I am customizing the Issues Database Template (from the MS Template page)  
http://office.microsoft.com/en-us/templates/TC012186931033.aspx  to use with
projects.
I have two tables and a one form that I am working with. There are (2) two
fields/columns named "Project Name" and "Comm Name", respectively in each of
the Issues Table and Projects Table that correspond to two fields on the
Issues form. For every Project Name there is a unique Comm Name. The fields
on the Issues Form are  named "Project Name" (formerly the Category field)
and  (a newly created field), "Comm Name".

I have tried several ways to do this, using the Controls on the form itself,
and/or by using queries, but none seem to be working. So, now I'm a bit
confused about whether to use an Update or Inner Join Query? And if either of
these are the solution, could someone help with the correct syntax! Grrrrhhh!
Because even after searching books and the online MS Office Assistance - for
correct syntax for queries -  I've tried just about everthing -  but nothing
seems to be working.

I would like to do the following:  (basically populate the field from one
table based on control / or field from another table).

1) Populate the "Comm Name" field in the Issues Table with the corresponding
Comm Name, using data from the Projects Table - based on the Project Name
(field) that is entered in Issues Table.  In other words, when I enter the
Project Name in the Issues Form  - or the Issues Table, I would like to the
Comm Name to automatically appear.  The Project Name field is a Combo Box,
while I would like the Comm Name to be a simple text box (which is locked -
no data entry allowed) in the Issues Table or the Issues Form.

2) When the Issues form is open during data entry, I would like the Comm
Name to appear (in a locked field)  -when the Project Name is entered into
the Project Name field (which is a Combo Box). -Of course - as with all of
the other fields (I'm hoping that the control on that field will
automatically populate the Issues Table- based on what is entered into the
Issues Form.

If someone has a solution to this problem. I would be most appreciative. The
process of populating fields based on data in another field is pretty
frustrating.
Thanks so much in advance.

Sarah