update query on lookup field produces errors

[smwabill]

I have an orders table and I have a product table

the orders table has a lookup or link to the products table. the fields I'm linked to in the lookup is productnumber and productname the number is masked
so only the name shows.

but, when I try to update the productname in an update-query showing the orders, it won't let me do it
unless I put in the product number, and I don't want to use the product number, I prefer using the name.

Thanks.

 

[smwabill]

Thanks I'll try it later. Someone at utteraccess in the meantime had figured one way to do it.


You can find the post here:

http://www.utteraccess.com/forums/showflat.php?Cat=&Number=670250

Thanks,
smwabill