..........................................
*Table A*
Item Code
JP Code
Qty per case
..........................................
*Table B*
Item No
Lot No
Qty
..........................................
Use Table B to make a query,
I also want to show Table A field "Qty per case",
base on Item No<>Item Code,
if I use two table in query, I can't input new record,
is it use "Dlookup" to show this field "Qty per case"?
Hope somone can help to give me a sample,
Thank very much!!
*Table A*
Item Code
JP Code
Qty per case
..........................................
*Table B*
Item No
Lot No
Qty
..........................................
Use Table B to make a query,
I also want to show Table A field "Qty per case",
base on Item No<>Item Code,
if I use two table in query, I can't input new record,
is it use "Dlookup" to show this field "Qty per case"?
Hope somone can help to give me a sample,
Thank very much!!