Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Database > BOOK: Beginning Oracle Application Express ISBN: 9780470388372
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old August 25th, 2009, 01: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
Reply With Quote
  #2 (permalink)  
Old August 25th, 2009, 08:03 AM
Friend of Wrox
Points: 793, Level: 10
Points: 793, Level: 10 Points: 793, Level: 10 Points: 793, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2005
Location: OKC, OK, USA.
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.
Reply With Quote
  #3 (permalink)  
Old August 26th, 2009, 01: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.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cascading forms, form start locations pigparent Visual Basic 2005 Basics 3 June 27th, 2008 11: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 02:00 PM
alter LOV items lucid Oracle 1 April 13th, 2004 07:04 AM
LOV shamsad Oracle 1 March 10th, 2004 02:41 PM



All times are GMT -4. The time now is 12:38 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.