I am working on access 2010 i have a problem on retrieving of a value form other table,I created Table1 having product name,cost and in Table2 i created
quantity as a field and look-up product name from table 1 my task is if i select product name then how can i get the it's cost automatically from Table 1 to Table 2 i knew to create a look up but it doesn't look good .I
hope you will respond to me.
Taking your precious time and responding to me i,I am getting problem on retrieving data actually my task is .I have 2 tables one
table contain ( "Product name" and "cost") in second table i have( product field which is a look-up from table1 and cost field ,quantity and total) .My task is when i select the product in
second table i should get the selected product's from cost table one
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.