I'm working on an billing application, where I have two tables one contains the Project Manager table which contains the detail of a person and to what project he is PM. These PM can designate people as Proxy.
The PM table is refreshed data from other database source viz SAP and the Proxy PM table gets updated when the PM allocate Proxy for the project using the application.
The above is the setup and now i face a constraint that a person cannot be a PM and a Proxy PM for the same project. I tell u an scenario, when a person already existing as ProxyPM is designated as PM (by making changes in SAP) and when an entry is made against the same project code, the entry for the same should be deleted from the Proxy PM table.
In case if you need the fileds that are in the table is
ProjectManager Table: (which gets updated from other source)
Emp# Projectcode PMEmp#
ProxyPM Table : (which gets data from the application) it has the same fields as the ProjectManager table.
Kindest Regards,
Arunkumar
Reputation is what other people know about you. Honor is what you know about yourself."--