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.
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.