hi,
I have some tables called suppliers , products,
inI the supplier table I have say 25 supplier , and in the products table I have about 200. these products are split between the 25 suppliers
then i create a purchase order i ust a form called "purchase orders " and a sub form called " purchase order detiails
when i create a new p/o i select the supplier , expected delivery date , submitted by, and approved by in the " purchase order form" then in the subfrom i use a drop down box to select the items i need from the 200 items which belongs to that supplier ( seems long way of doing it ?)
how can it be changes so either when i select the supplier it automanaticall out all there product in my form " purchase order details " form and i just enter the qty for each item
it then looks at the next upplier and does the same .
just runs thro all the suppliers creating orders until all the parts have been ordered
thanks steve
I have some tables called suppliers , products,
inI the supplier table I have say 25 supplier , and in the products table I have about 200. these products are split between the 25 suppliers
then i create a purchase order i ust a form called "purchase orders " and a sub form called " purchase order detiails
when i create a new p/o i select the supplier , expected delivery date , submitted by, and approved by in the " purchase order form" then in the subfrom i use a drop down box to select the items i need from the 200 items which belongs to that supplier ( seems long way of doing it ?)
how can it be changes so either when i select the supplier it automanaticall out all there product in my form " purchase order details " form and i just enter the qty for each item
it then looks at the next upplier and does the same .
just runs thro all the suppliers creating orders until all the parts have been ordered
thanks steve