J
jbarna
help
here is my problem i have a db that tracks orders and i need a form to
enter the order number and part number and quantirty.
i will need to enter allot of orders at one time so i want to use a
comtinuous form to enter the info into the orders table
what i want to do is enter the job # and the part number and auto fill
the discription and size. i have a part numbert tabel with fields part
number, discription size there are too many to use a combo box.
i have an order table with fileds
job number, part number , discription , qantity, start time end tine,
efficentcy, total time , down time,
is there a way to enter a job number and part number and look up part
number table find the dicription and size insert that info into the
next to unbound text boxes in the coutinuous form bound to the order
table?
any ideas would be a great help
thanks in advance
here is my problem i have a db that tracks orders and i need a form to
enter the order number and part number and quantirty.
i will need to enter allot of orders at one time so i want to use a
comtinuous form to enter the info into the orders table
what i want to do is enter the job # and the part number and auto fill
the discription and size. i have a part numbert tabel with fields part
number, discription size there are too many to use a combo box.
i have an order table with fileds
job number, part number , discription , qantity, start time end tine,
efficentcy, total time , down time,
is there a way to enter a job number and part number and look up part
number table find the dicription and size insert that info into the
next to unbound text boxes in the coutinuous form bound to the order
table?
any ideas would be a great help
thanks in advance