Can't get my Update query to work

[texas1014]

Hello,



I am very new at Access. I have created a table that holds two fields of data: Type and Example. The type is the type of product and the Example would be "bags and cables", or "Tower, Tablet". In another table, which I am calling the master table, I have under the field "Type of Product" the type as a dropdown using the values from the table I mentioned previously. That table is called "tblHW_SW". The master table I have titled "tblMasterItemFile". The goal of my query is to have the value under the field called "Example" on the "tblMasterItemFile" to be populated with the information on tblHw_SW.[Type of Product]. I brought the field [Example] down to the grid, and on the Update To field, I entered [tblHW_SW].[Example]. Nothing populates when I check the results on the datasheet view. I also have the two tables joined by Type of Product and Type.

Any suggestions?

What I want the table to do is automatically execute the Update query every time I update the value on the tblMasterItemFile.

Thanks,
Kevin

[pbaldy]

As suggested in your other thread, you shouldn't store the Example in the master file.

[texas1014]

I am looking at your example now. thanks for the feedback.

[pbaldy]

No problem.