My original question was how to get two fields (proj name and proj owner) to be automatically populated once a Mnemonic was selected.....Travis, the information you provided was helpful and it did work. I'm now running into an error while trying to add an issue. I can now select a "new" or an "existing" project...and have automatic updates....but when trying to create new issue for that project I'm now running into errors...."changes not successful because they would create duplicate values in the index, primary key or relationship..Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again (Access Error). Please Help...Anyone...Travis you'll be more familiar.

This sounds like you have the Index field set to don't allow duplicates. Make sure you don't have the Index field set to the text field you are updating. Use the don't allow duplicates on fields that are never suppose to have the same entry more than once. I usally only use this property on an Autonumber or Social Security Number field to avoid duplicate entries.

Hope this is helpful.

You can still index the field just don't set the don't allow duplicates.