Path: utzoo!utgpu!jarvis.csri.toronto.edu!rutgers!tut.cis.ohio-state.edu!unmvax!indri!ames!elroy!cit-vax!citron From: citron@cit-vax.Caltech.Edu (Mark C. Citron) Newsgroups: comp.databases Subject: Re: Question about Oracle SQL*Forms Keywords: oracle forms master detail Message-ID: <11071@cit-vax.Caltech.Edu> Date: 17 Jun 89 21:40:26 GMT References: Reply-To: citron@cit-vax.UUCP (Mark C. Citron) Distribution: comp Organization: California Institute of Technology 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. >Thanks in Advance for any help anyone can send my way. >-- >Jeff Lawhorn >lawhorn@opti >opti!lawhorn@berick.uucp >ucsd!sdsu!berick!opti!lawhorn Jeff, There is a cute trick you can use to create master detail relationships without hardly any typing at all. Before you start making the form with sqlforms let easysql create the initial form. It can add all the triggers you need for a good master/detail organization. Of course you are out of luck if you dont have easysql for if you have already start the form since modifying it with easysql will mess up your formatting. If you have already started it, you can create a two column form with easysql and just review the triggers it puts in. There seem to be the same as those already mentioned in other replies to your questions although it does add a few new tricks like jumping to the first or last row of the detail depending on the direction you are going in the master. It all works fine as far as I can tell. Contact me if I can be of more help. Mark Citron citron@csvax.caltech.edu citron@cit-vax.caltech.UUCP