Database Programming

[i.draw.fast]

---

Good day istoryan programmers.

Naa ta ko patabang ninyo ug himo ug database amo dtr/payroll system. Kamao ko gamay muhimo ug access using relationships pero bagsak nako sa vb progamming niya.

Maka-ingon ko nga dili pwede sa skills nako sa access kay kinahanglan man i-program kay matrix style organization mi. Same people on different projects.

Like ingon ani pagkaset-up ba:


I'm not familiar with prepackaged systems pud pero murag 90% sure ko dili muwork sa amo set-up.

Wala nako time nga magtuon sa VB kay busy sa work. If interested mo, pm lang nako or text me 0922-8167018.

For serious programmers only. Thanks.

[nullpointer]

Mura naman ug ERP ang imo diagram?

[i.draw.fast]

dili man ERP gyud.

gamay raman ang people then i-balhin sila ug assignment per project.

Example:

electrician 1

2 days sa project 1
3 days sa project 2
2 days sa project 3

dili ingon 3 electricians each working on a project.

ERP gihapon na?

[fixyourself]

dili man ERP gyud.

gamay raman ang people then i-balhin sila ug assignment per project.

Example:

electrician 1

2 days sa project 1
3 days sa project 2
2 days sa project 3

dili ingon 3 electricians each working on a project.

ERP gihapon na?

nop, if dtr/payroll system ra, it will never be an ERP.

[fixyourself]

dili man ERP gyud.

gamay raman ang people then i-balhin sila ug assignment per project.

Example:

electrician 1

2 days sa project 1
3 days sa project 2
2 days sa project 3

dili ingon 3 electricians each working on a project.

ERP gihapon na?

Question:

Will electrician 1 have the same rate in all projects?

If that would be the case, all you have to do is file an employees DTR regardless the projects an employee is assigned, what matters is his time spent working, payroll can be computed out of it, unless rates may differ depending on the project, that would complicate your system.

Please clarify more