I have a modified version of CREloaded from a few years ago (2.2 I think)
1) I need to install and help configure QBI contrib... (we have the purchased version)
2) Create a form that can edit a data table tblPED in grid format.. (this table already exists.)
3) Create a tblPEDhistory table (and ensure the form in point 2 records changes to the a table tblPED which .
4) Create a master detail type form to View History of selected record from tblPED
5)Be pretty flexible about adding a table or two or fields etc to refine this idea and make it work.
6)Create a dynamic report based on the tblPED with joins to oscom tables (products, orders, products_orders) filtered.
7)Create a button in the header of all OSCOM pages that runs a SQL statement which will synch a tblPED master to (outside OSCom db) to the mirrored table inside the oscom db) And synchs certain OSCom db tables to a mirror of that data on another server.
If you want to break down you bid by number and only do part(s) That is fine. Also there may be better ways to do what I am hoping to do.. Lets talk about it!!