Hi All...
I'm a little confused on "process" and here's why...
My (database) system is comprised of over 200 tables (It's an enterprise level app)
The tables are grouped by module (Assets / Inventory / Purchasing / Work Orders etc...)
Each Module will have several applications (Add / Edit / Delete / Actions) for their respective modules
(Actions will be my custom code)
Now, all these modules and applications need to be "glued" together under one roof (Main Menu Page)
I performed a few tests last night (actually downloaded trial version yesterday and was simply amazed)
I built one application (Work Orders to insert / update and delete) basic work order data and it Worked perfectly 1st time. (Could'nt believe it)
However when I went back and developed the work order - work plan application and did the build, my work order application stop functioning and only the work order - work plan application worked.
As an example (Work Orders Module consists of)
Work Orders - High Level Work request Info
- Work Plan - Labor - Planned labor for the work order (Data comes from Labor Table)
- Work Plan - Materials - Planned Materials for the work order (Data comes from Inventory Table)
- Work Plan - Tools - Planned Tools for the work order (Data comes from Tools Table)
- Work Plan - Operations - Planned "Work Instructions" for the Work Order
- Report Labor - Report Actual Labor used on Work Order (Triggers updates LaborTrans, Labor and main workorder tables)
- Report Materials - Report Actual materials used on Work Order (Triggers updates MaterialTrans, Inventory and main workorder tables)
- Report Tools - Report Actual Tools used on Work Order (Triggers updates ToolTrans, Tools and main workorder tables)
What would be the "process" to build this module of applications?
I'm a little overwhelmed!
