Wrox Programmer Forums
|
BOOK: Beginning Oracle Application Express ISBN: 9780470388372
This is the forum to discuss the Wrox book Beginning Oracle Application Express by Rick Greenwald; ISBN: 9780470388372
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Oracle Application Express ISBN: 9780470388372 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 25th, 2009, 12:59 AM
Registered User
 
Join Date: Aug 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Cascading LOV in tabular form using ajax

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
 
Old August 25th, 2009, 07:03 AM
Friend of Wrox
 
Join Date: May 2005
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
Default

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.
 
Old August 26th, 2009, 12:43 AM
Registered User
 
Join Date: Aug 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Cascading forms, form start locations pigparent Visual Basic 2005 Basics 3 June 27th, 2008 10:34 AM
Setting Text Fields in a Tabular Form Nadine Access VBA 2 January 17th, 2007 01:57 PM
Two controls with tabular data - which ones? pettrer ASP.NET 2.0 Professional 3 April 5th, 2006 01:00 PM
alter LOV items lucid Oracle 1 April 13th, 2004 06:04 AM
LOV shamsad Oracle 1 March 10th, 2004 02:41 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.