OraFAQ Forum: Forms » I want to populate form (Daily Attendance Form).

Home » Developer & Programmer » Forms » I want to populate form (Daily Attendance Form).

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

I want to populate form (Daily Attendance Form). [message #114879]

Wed, 06 April 2005 01:02

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

I have a table for attendance.
Tbl_Daily_Attendance
Col_Sno (PK)
Col_Empno (FK of Tbl_employee)
Col_Att_Date
Col_Status

I want that when my user open attendance form. The form will populate all empno from employee table to the attendance form.

Advice Requested.

Wishes
Jawad

Report message to a moderator

Re: I want to populate form (Daily Attendance Form). [message #114881 is a reply to message #114879]

Wed, 06 April 2005 01:09

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Assuming that one have only one block, or that the opening block is the one you want to use, in trigger When-New-Form-Instance:
begin
execute_query;
end;

Report message to a moderator

Re: I want to populate form (Daily Attendance Form). [message #114916 is a reply to message #114881]

Wed, 06 April 2005 06:22

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

Dear Djmartin

thanks for your help. But it is not all man
I have more then one tables.

thanks
Jawad

Report message to a moderator

Re: I want to populate form (Daily Attendance Form). [message #115032 is a reply to message #114879]

Wed, 06 April 2005 20:04

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

If this is an exercise for a computing course: READ THE BOOK and work with your colleagues.

The 'Guidelines for Building Applications' book is at http://www.oracle.com/technology/documentation/dev_arch.html.

If this is a business task please supply more details.

Report message to a moderator

Previous Topic:	SQL Loader
Next Topic:	form objects

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 18:04:09 CDT 2024