Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!rutgers!mailrus!csd4.milw.wisc.edu!leah!albanycs!crdgw1!uunet!murtoa.cs.mu.oz.au!munnari.oz.au!bruce!trlluna!tyers From: tyers@trlluna.trl.oz (P Tyers) Newsgroups: comp.databases Subject: Re: Question about Oracle SQL*Forms Summary: it can be done =- example quoted Keywords: oracle forms master detail Message-ID: <700@trlluna.trl.oz> Date: 15 Jun 89 00:20:58 GMT References: Distribution: comp Organization: Telecom Research Labs,IPF,Melbourne, Australia Lines: 30 In article , lawhorn@optis31.uucp (Jeff Lawhorn) writes: > > I have 2 tables that I need to establish a master/detail > relationship between. Much like the relationship between the > orders table and the lineitems table in the Forms Tutorial. The > big difference, and one I have not been able to overcome as of > yet, is that I need to have the detail records displayed each and > every time the master record is displayed. I do not (can not) > want the user to have to switch blocks to call up the detail > records. > It is possible to do this quite easily (albeit with much key-trigger writing) in fact ORACLE even gives a (for ORACLE) lucid example. Check out SQL*Forms Reference manual (ours is Version 2.0 part # 3304-v2.0) section on trigger syntax (Chapter 9) Examples of SQL*Forms Triggers example 6 where they set up triggers to align header and detail records following use of [NEXT RECORD] key. Similiar actions need be taken as post_query on the master block, [PREV REC] etc. I have a number of forms doing this, even to the extent of aligning two detail blocks with the master block, but dont really want to clog the net with voluminous *.inp files. -- P Tyers, Tel. +61-(0)3-5416794 JANET tyers%trlluna.oz@uk.ac.ucl.cs ACSnet tyers@trlluna.oz UUCP {uunet,hplabs,ukc}!munnari!trlluna.oz!tyers CSnet tyers@trlluna.oz ARPAnet tyers%trlluna.oz@uunet.uu.net MAIL: Telecom Research Laboratories,P.O. Box 249,Clayton,VICTORIA 3168,AUSTRALIA