form

[jervin via AccessMonster.com]

Hi
i have 2 tables: table1 & table2

Table1 has a data stored already it has a field name sotckno,qtyonhand,
description,partno,serialno etc..My table2 is actually no data yet, it has
field name customer,customerid,stockno,description,qty_issue,recvdate etc..

table2 will be the table for all the customer that i will be issuing the item.


Now, i want to create a form that will ask me to enter the stockno or a
partno and will then verify into my table1 if the stockNo is available or not.

if the item is vailable it will show the detail information and i could be
able to issue it to the customer..The qtyonhand from table1 will then be
subtracted from the qty that i issued to customer.

i dont know how to start a form for this, anyone can help me pls

Pls note also that i will be issuing more then one(1) item to the customer.

pardon me for my grammar..thank you again..