Question Auto Create Orders and Products Every Week

[Mohsin Malik]

Hello there!

I have an Access database that contains Orders and its delivery status with the sub table Products that have relative records of the order, I want to Auto Create the New Order with the Same Products (sub tables that have foreign key of Order Id) on the order due date, any idea how to do that so whenever the order is due, it will be auto created with the same specs which i will change manually!

Thank you for the help
Mohsin

 

[jdraw]

Here is a link to a tutorial to take your ideas/needs/specs and create a database with normalized tables and relationships. This will give you a good foundation.
http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip

Good luck.