Drawing numeric value from another table

Drawing numeric value from another table

Hi - I've consulted the Forums on this topic but can't seem to make this work.

I have a numeric value in one form - form is Product Information, field "Number" -  and I want to import this value into a second form- Product Cost - so that I can use the "Number" value as part of a formula. In the second, "Product Cost," form, I set up a field and tried to import the "Number" value from the "Product Information" form, but I can't seem to make "Fetch" work. In the first form, the "Number" corresponds to a specific "Product Name," so I am also trying to import the "Number" that is associated with the same "Product Name" that is used in the "Product Cost" table.

Thanks for any help.

JLS