469,625 Members | 1,089 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,625 developers. It's quick & easy.

Append Query Problems

I have a form that has a combo box thats displays all the suppliers

I then have subform that shows all the products that we buy from them
and how many have been bought and sold therefore work out stock
remaining
I then have a button that runs a append query that opens up a Purchase
order form with a subform that has the products that have to be bought

When i run the query it copys the product code into the Purchase order
Subform with no problem

what i would like to do is on the stock remaing form is be able to type
the amouth i need to reorder in a field then when i run the query it
puts the quantity to be reoreded into the Purchase order subform
If any one could tell me how to do this as the i have no idea how this
could be done

Thanks

Jan 5 '07 #1
1 2964
S.*******@shos.co.uk wrote:
I have a form that has a combo box thats displays all the suppliers

I then have subform that shows all the products that we buy from them
and how many have been bought and sold therefore work out stock
remaining
I then have a button that runs a append query that opens up a Purchase
order form with a subform that has the products that have to be bought

When i run the query it copys the product code into the Purchase order
Subform with no problem

what i would like to do is on the stock remaing form is be able to type
the amouth i need to reorder in a field then when i run the query it
puts the quantity to be reoreded into the Purchase order subform
If any one could tell me how to do this as the i have no idea how this
could be done

Thanks
I charged a company development cost of $2K to come up with an ordering web
page. All of the calls were made within the database itself (all html and store
procedures). Although, it was not MySQL.

We here, would be more than glad to assist, provided you make the first cut. If
I have to design the whole thing... well, that's why I do consulting on occassion.

--
Michael Austin.
Database Consultant
Jan 6 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by David Barger | last post: by
4 posts views Thread by pmacdiddie | last post: by
7 posts views Thread by wade.wall | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.