dude, i see what you mean now!

the reason why we have to make as many procs as possible is coz this is for an assignment, and we get marks for watever we do. but we havent exactly been taugh how to attach the procs to Forms, so thats where we get difficulty. I am hoping that i can adapt the help you give me to the other procs i have.

ok, so if i do the simple insert using the datablocks, do i have to structure the insert line like the table? ie:

This is my promotions table. it is called ADVANCEMENTS.

ADVANCEMENT_DATE NOT NULL DATE
NEW_GRADE VARCHAR2(2)
LAST_ADVANCEMENT_DATE DATE
OLD_GRADE VARCHAR2(2)
WRKFRCE_WORKFORCE_ID NOT NULL VARCHAR2(5)

When i write the Insert query are the the values in order of the above?

Insert into Advancements values (AdvancementDate,:datablockname:NGrade,'',OldGrade,WF_ID);

Thanks........