Dear All,

1. I first create form with form with report region.
2. Next on the form with report region , I create form with Tabular form.
3. In the form with Tabular form, out of 15 columns, I have two columns dept name lov ,emp name lov.
4. Now based on the dept lov, I have to select emp lov in form with tabular form

Can I do it with ajax + demand process+ javascript without using select list with submit button?.

Thanks in advance.

Looking forward for early response.
Thanks and Regard,
Sd

Steward:
I am not familiar with Ajax, so my response is based on the following "if-s":

• Use the Master-Detail Form, if you are assigning Employees to a particular Department AND your table for the Employee has the Department ID as the Foreign Key (FK). The Department's Primary Key (PK) is passed to the Employee Table on the detail portion on the form. Follow pages 39-46 in the Oracle Apex Book to assist in creating and testing the Master-Detail Form/pages.

Hope this helps.

__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.

Dear All,

I do appreciate your reply to my query.I am quite greatfull to you.But I think you have misunderstood my requirement.I follow the following steps
1. I have first created a form with form with report region.
2. Next on the form with report region , I create form with Tabular form.
3. In Tabular form I have 2 lov i.e emp lov & dept lov.
Note : The user is allowed to add /delete records from tabular form when he is in create or edit mode.

I have to select each time for each record ,dept lov and based on it the emp lov should populate in tabular form.It is quite easy if we have to use in form with report region.My requirement is in tabular form where for each individual record I have to use dept lov & based on it I have to populate emp lov.
Note:As you have mentioned, it has all the relation of the primary key,Foreign key.

Hoping for early reply.

Thanks in advance.
Sd.