Order Return Form, in Northwind

[bee55]

Hi every body
I'm working on northwind database,
i would like to add a form to handle Order Returns
i want to make a button in order Return form to clone the specified data in sales order and retrieve its data to the order return form
thanks

 

[jdraw]

Sounds reasonable. You may want ot consider Back Orders, Partial Orders, Reorder Level, Substitutions..... What exactly is the issue?

 

[bee55]

Yes, i mean Back orders

 

[jdraw]

Back Order
Substitution
ReOrder Point / Level

These may give you a starting point.
You could also look for data model with Back Order.
I don't have a recent NW database.
Good luck.


Note: There is a lot of info on Inventory management (related to Oracle) but good concept. May be too deep for your situation, but you can review and decide.
Can you zip a copy of your db or relationships window?

 

[bee55]

Back Order
Substitution
ReOrder Point / Level

These may give you a starting point.
You could also look for data model with Back Order.
I don't have a recent NW database.
Good luck.


Note: There is a lot of info on Inventory management (related to Oracle) but good concept. May be too deep for your situation, but you can review and decide.
Can you zip a copy of your db or relationships window?

sorry it is ecceed the maximum allowed size
it is 27 MB
and maximum allowed size for Accdb only 2 MB

 

[jdraw]

You can do a Compact and Repair to reduce unusable space in your database. Then make a zip file and attach.