Entering Orders With Multiple Lines (A97)

Topic

New Reply

I am working on an inventory app for some friends.

They need to be able to enter a customer order, and have it subtract the order from inventory and print labels for the items.

I have the subtract from inventory and print labels piece but what I don’t have is a good way for them to “see” the order as they are building it.

Right now I have them select the appropriate items from dropdowns and hit “Add to Order” but they can’t see, or revise, the order.

I’m looking for a simple way for them to “see” the order as it’s being built and possibly ammend it if necessary.

Any suggestions? The simpler the better…

Thanks!

Reply | Quote

Replies

How do you work now ?
You could use a main form for the order and a subform to enter the order lines, something like the order form in the Nothwind sample database.

Reply | Quote

[indent]

---

How do you work now ?

---

[/indent]
They have a pad of paper and write it down…
[indent]

---

You could use a main form for the order and a subform to enter the order lines, something like the order form in the Nothwind sample database.

---

[/indent]
I’ll have to look…I’ve never really looked at that database…

Reply | Quote

Thank you, Francois, that is exactly what I think I need!

I’ll have to change my design a bit to make it work, but it will be well worth it!

Reply | Quote

Thank you, Francois, that is exactly what I think I need!

I’ll have to change my design a bit to make it work, but it will be well worth it!

Reply | Quote

[indent]

---

How do you work now ?

---

[/indent]
They have a pad of paper and write it down…
[indent]

---

You could use a main form for the order and a subform to enter the order lines, something like the order form in the Nothwind sample database.

---

[/indent]
I’ll have to look…I’ve never really looked at that database…

Reply | Quote