NetNews Usenet Archive 1992 #27/NN_1992_27.iso/spool/comp/database/7965

Text File | 1992-11-19 | 1.6 KB | 35 lines

Newsgroups: comp.databases
Path: sparky!uunet!zaphod.mps.ohio-state.edu!caen!destroyer!cs.ubc.ca!unixg.ubc.ca!kakwa.ucs.ualberta.ca!access.usask.ca!mizar.cc.umanitoba.ca!ummalik
From: [e-mail] (Ijaz Rashid Malik)
Subject: MANY-TO-MANY mess in Paradox!!!
Message-ID: <[e-mail]>
Sender: [e-mail]
Nntp-Posting-Host: asimov.cc.umanitoba.ca
Organization: University of Manitoba, Winnipeg, Canada
Date: Fri, 20 Nov 1992 00:44:56 GMT
Lines: 23


Is it just me or does every one is unhappy withg Paradox's way of handling
many-to-many links. I always end up with extra tables and lots of redundant
information. In a typical scenerio (sp?), a product can be supllied by
many vendors and a vendor can suplly many products. When it comes to
displaying either side of this info, paradox suggests extra tables and their
use in the "form" display/generation. It, however, doesnot suggest an
answer to following problem....

say, from an input screen I am entering info about new products or new
suppliers. If its products, it can have a variable number of vendors and
if it is a vendor, there could be a variable # of products for it. How can
I design an input screen/form that has linked tables on it and handeles
multiple entries for a given field. I mean I can use Products as master
form and use vendors as linked embeded form. Now when ever I enter a new
product, I am not sure how many vendors for this product there will be.
Could be 0,1, or 10000!!! How can I design an input screen and then table
which would handle this situation????

Thanks very much for help.

Malik
[e-mail]