I'm in the midst of programming a CMMS, by myself and never done it before, and I am in need of some insight. I'm learning new ways to operate Alpha 5v7 everyday but I am still far away from knowing enough to solve design problems. The business I work for needed a computerized maintenance management software that handles every day work.
Stock/Special Purchases by the Parts Department.
Equipment Maintenance Schedules.
Daily Work Orders including Easy/Medium/Estimated Jobs.
There's a lot more involved, but just this small scope is a lot to deal with for me. I guess I'm just sharing this stuff because I'm hoping maybe someone can help in my quest.
Is it reliable to link two tables using an expression involved two fields? It seems obvious any new record on the child table will need the two field values implanted to complete the link. I am using this for my Part Inventory aspect of the program.
It goes like this, All parts have an inventory number (non symbolic, and sequential). This Inventory number is used to link an equivalent part but with either a different Part_No or different Vendor.
Inv No 1:M Part_Id/Vendor (Inv_NO to Inv_NO)
Part_ID/Vendor 1:M Purchases (Part_Id/Vendor to Part_ID/Vendor)
I did this so that purchases for the same Part_Id from two different vendors would show the purchases separately. This also handles equivalent parts but with different Part_ID's all grouped under the same Inv_NO. So Inventory number can actually handle any number of part_ids.
My question is: Is this a suitable way to handle more than one part ID for the same exact part, and also split the vendor purchases for the same Part_ID?
A lot of this I have dreamt up because of various needs vs my lack of knowledge. Can anyone elaborate?
Stock/Special Purchases by the Parts Department.
Equipment Maintenance Schedules.
Daily Work Orders including Easy/Medium/Estimated Jobs.
There's a lot more involved, but just this small scope is a lot to deal with for me. I guess I'm just sharing this stuff because I'm hoping maybe someone can help in my quest.
Is it reliable to link two tables using an expression involved two fields? It seems obvious any new record on the child table will need the two field values implanted to complete the link. I am using this for my Part Inventory aspect of the program.
It goes like this, All parts have an inventory number (non symbolic, and sequential). This Inventory number is used to link an equivalent part but with either a different Part_No or different Vendor.
Inv No 1:M Part_Id/Vendor (Inv_NO to Inv_NO)
Part_ID/Vendor 1:M Purchases (Part_Id/Vendor to Part_ID/Vendor)
I did this so that purchases for the same Part_Id from two different vendors would show the purchases separately. This also handles equivalent parts but with different Part_ID's all grouped under the same Inv_NO. So Inventory number can actually handle any number of part_ids.
My question is: Is this a suitable way to handle more than one part ID for the same exact part, and also split the vendor purchases for the same Part_ID?
A lot of this I have dreamt up because of various needs vs my lack of knowledge. Can anyone elaborate?
Comment