| problem in inserting [message #197445] |
Wed, 11 October 2006 05:03  |
lalylatheef
Messages: 8
Registered: October 2006
|
Junior Member |
|
|
i have two tabs employee wise and course wise. In the emplyee wise tab, the insert is working. but not in the course wise. the purpose of these tabs are for the convenience of the employees. ie. once course can be taken by the employees at one time. or one employee can take different courses at different times. here is the table and i have attached the form also. plz help
CREATE TABLE HR_TRAINING
(
EMP_ID VARCHAR2(10) NOT NULL,
COU_ID NUMBER(4) NOT NULL,
START_DATE DATE,
END_DATE DATE,
RESULT VARCHAR2(20),
REMARKS VARCHAR2(100),
MODI_USER VARCHAR2(50),
MODI_DATE DATE,
approved varchar2(3),
approved_by varchar2(15),
paid varchar2(3),
REF_NO VARCHAR2(3),
AMOUNT NUMBER(10,2))
/
[Updated on: Wed, 11 October 2006 06:43] Report message to a moderator |
|
|
|
|
|
| Re: problem in inserting [message #197638 is a reply to message #197619] |
Thu, 12 October 2006 02:18  |
lalylatheef
Messages: 8
Registered: October 2006
|
Junior Member |
|
|
i have total four blocks .. 2 in each tab
employee wise
control block: to to select the particular employee
training: to select the list of courses for that employee
course wise
control1: to select the particular course
training1: to select the list of employee for that course
you can check the form that i have attached. can ugive me the solution
|
|
|
|
| Re: problem in inserting [message #197837 is a reply to message #197638] |
Thu, 12 October 2006 20:02 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
I don't like your data structure design. Using your current approach you MUST commit your changes when moving from one tab to the other. Yo also have to requery the block as they are both based on the same table.
David
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
