Message-Id: <10620.117140@fatcity.com> From: "Guidry, Chris" Date: Fri, 15 Sep 2000 11:00:33 -0600 Subject: RE: Is it possible to create Matrix FORMs Hi, Check out the following link. It is not exactly what you want but it may give you some ideas. http://www.oracle.com/oramag/code/cod09308.html - Chris J. Guidry P.Eng. ATCO Electric, Metering Services Phone: (780) 420-4142 Fax: (780) 420-3854 Email: chris.guidry@atcoelectric.com > -----Original Message----- > From: prashasta gujrati [SMTP:gujrati@TUBES.TATASTEEL.COM] > Sent: Thursday, September 14, 2000 1:11 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Is it possible to create Matrix FORMs > > > Hi Elkins, > > Thanks for your interest. > > I'll briefly tell about the application for which I'm looking for > such a solution. > > This is a Demand allocation application where there is demand for > certain products from various regions. This demand is in form of > Orders placed on manufacturing unit. Allocation is to be done > manually keeping in mind the proper distribution of products to > various regions. > > Table structures are like this : > > region_codes > -------------- > region_code > description > > part_master > ------------- > part_no > description > > oeorder_release > ----------------- > order_no > part_no > region_code > demand_qty > allocated_qty > (order_no + part_no is the primary key) > > The screen layout which I have in mind is : > > region1 > region2 region3 > region4 > > Order1 demand allocation Order4 demand > allocation Order7 demand allocation ....... > Part_no1 Order2 demand allocation Order5 demand > allocation Order8 demand allocation ....... > Order3 demand allocation Order6 demand > allocation Order9 demand allocation ....... > > Order11 demand allocation Order14 demand > allocation Order17 demand allocation ....... > Part_no2 Order12 demand allocation Order15 demand > allocation Order18 demand allocation ....... > Order13 demand allocation Order16 demand > allocation Order19 demand allocation ....... > > Order21 demand allocation Order24 demand > allocation Order27 demand allocation ....... > Part_no3 Order22 demand allocation Order25 demand > allocation Order28 demand allocation ....... > Order23 demand allocation Order26 demand > allocation Order29 demand allocation ....... > > and so on... > > Then there are totals as well which have to be shown at various levels. > > It is as if we are trying to get Excel spreadsheet kind of functionality > out of > > forms. > > Any ideas will be greatly appreciated. I've tried checking metalink but it > did > not help. Looking for ideas from you guys... > > TIA, > > LGE wrote: > > > Can you give a little more info on what you mean? Maybe a high level > > description of the tables, some sample data, and a rough diagram of how > you > > expect the data to be presented. I have a couple of ideas of what you > might > > mean; but, I don't want to waste time working up an answer that isn't > > relevant to what you need. > > > > Regards, > > > > L. Elkins > > > > Author: LGE > > INET: elkinsl@flash.net > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California -- Public Internet access / Mailing Lists > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > Author: prashasta gujrati > INET: gujrati@tubes.tatasteel.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may