2 more items Sambo
Hi Sambo,
1) I tried to import as fresh Employee file into the tblEMP and a Department head file into the tblDepthead tables. Problem is, When I attempt to import 1675 Job position records into the table i get a "Validation" error and it wants to only import 746 records. Is there a way that i can get all records.
2) This is a situation that was brought up today, There are departments that may have more than 1 of the same job position listed due to different people in those positions. Not sure if you will understand this but, What needs to be done(If possible) is, If a department has more than one of the same job position, instead of clicking the next position icon and having it click through (Example) 4 or 5 RN III's, is there a way to only move to the next RN III IF the "Position Qualifier" field gets populated with data. In other words, In most cases, the PHI elements will apply to all "duplicate job positions" within a department. If one of the dupluicate positions listed (Example: RN III's) gets a different set of PHI qualifiers, then some how allow the next position icon to show another RN III. This is hard to explain so i will try this in a nutshell: No matter how many of the same job positions full under any particular department, They only want to be able to scroll through more than one of the same positions IF there are different position qualifiers that apply. I would imagine that the trigger for this would be something like: if position Qualifier is "Not Null" then ..........(somehow allow for another (duplicate) job position. Sorry if this is not clear, it's hard to explain in type. Thanks