Home » Developer & Programmer » Forms » Forms Help ... Urgent Plz ...
Forms Help ... Urgent Plz ... [message #128306] Sun, 17 July 2005 14:36 Go to next message
sanjayapps
Messages: 49
Registered: May 2005
Location: Richmond
Member

Hi Gurus,

I was assigned a Master detail form to develop and I need your help in solving this... I attached the screen layout for this form ...

The Form basically has a Many-to-Many relationship between the two blocks. The first Frame is related to the Master Block and the second frame is related to Detail block.

Rule 1 : Here when you select an adjustment type(i.e.) the primary key column of the master table (imp. point is this is an LOV), the records in the detail table should dynamically change and gets displayed in the 2nd Frame which is related to Detail table and detail block and Vice-Versa

Can anyone send me the sample code or .fmb file that achieves this functionality.


Your help and quick response is deeply appreciated ...

Re: Forms Help ... Urgent Plz ... [message #128624 is a reply to message #128306] Tue, 19 July 2005 19:26 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
This sounds like a standard master-detail. Unfortunately, going from detail to master is more difficult but rarely required. It is sometimes asked for but upon discussion with the user is found to be not necessary.

Search this forum for 'master' and 'detail', samples have been given often before.

David
Previous Topic: Integrating Oracle Forms with Rich Text Formatting
Next Topic: One problem in form design
Goto Forum:
  


Current Time: Thu Sep 19 23:02:19 CDT 2024