Message-Id: <10620.117166@fatcity.com> From: "Gogala, Mladen" Date: Fri, 15 Sep 2000 15:10:31 -0400 Subject: RE: Is it possible to create Matrix FORMs Matrix is all around you, just be careful with those pills. Oracle has the "varray" structure which can accomplish what you are trying to do. Create a new type containing the varray structure, name it row_type for example and create a varray with the elements of the row_type type. -----Original Message----- From: prashasta gujrati [mailto:gujrati@tubes.tatasteel.com] Sent: Thursday, September 14, 2000 3: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