Oracle-L: RE: How to populate many-to-many

From: Karniotis, Stephen <Stephen_Karniotis_at_compuware.com>
Date: Tue, 21 May 2002 09:55:41 -0800
Message-ID: <F001.0046629A.20020521095541@fatcity.com>

I would follow the exact approach that Forms gives you with drop down lists. You would then have the actual table fields filled in with background/hidden fields within the application.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation

Direct:	(248) 865-4350
Mobile:	(248) 408-2918
Email:	Stephen.Karniotis_at_Compuware.com
Web:	www.compuware.com

 -----Original Message-----
Sent:	Tuesday, May 21, 2002 12:14 PM
To:	Multiple recipients of list ORACLE-L
Subject:	How to populate many-to-many

I am designing a database our software/hardware inventory and there is a many-to-many relationship between 'server' and 'software' table. So I created an association table between them to resolve this. While I believe this is the right thing to do, I am wondering how we are going to populate this association table.
It seems to me that we have to create a separate screen for this table to have the users manually enter the data. Right now this table has only three columns - ( server_software_id, server_id, software_id ). Bonus question - if we are going to use Access to manually enter data, is there any way we can avoid entering the raw numbers ( the association table columns are all numeric ). I remember with Oracle Forms you can set up some kind of drop down list where you pick the text value and the ids get populated behind the scene. I am not a fan of Access, can we do something similar?

TIA Dennis Meng
Database Administrator
Focal Communications Corp.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: dmeng_at_focal.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_at_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).

The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Karniotis, Stephen
INET: Stephen_Karniotis_at_compuware.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------