Re: How to use Perform to associate 6 tables?

Posted in 1992

Walt Hultgren {rmy} — Tue, 4 Feb 92 12:56:43 -0500 — source: Informix-list mailing list archive (1991-1998)

Path: emory!att!rutgers!ub!dsinc!das13!dave From: dave@das13.snide.com (Dave Snyder) Newsgroups: comp.databases.informix Keywords: Perform Message-ID: <1616@das13.snide.com> Date: 3 Feb 92 02:08:17 GMT References: <1992Feb2.000100.15169@skyking.uucp> Organization: Snide Inc. - Folcroft, PA In article <1992Feb2.000100.15169@skyking.uucp>, jc@skyking.uucp (J.C. Webber III) writes: > I am back to using Informix Sql for another medium size application > after over a year away from it. I'm kind of rusty and need some > assistance from you dbgurus. > > I have 6 tables in one db. One is kind of a personnel record. The > second is a department table with department numbers, manager, and > department names. The third table is about office space, it contains > cube number, twisted pair cable number, and current patch-panel > connection for the 8 ports available. The fourth table is for group-id > and group names. Number five contains all the information about the > host that serves this user. The 6th table is a history recording > mechanism for tracking changes made to the entire db and is joined > with a particular user's personnel table entry. The first thing that is needed is a similar field that is in ALL six tables. You might consider a SERIAL field in the personnel table called person_nbr. You then need an INTEGER field called person_nbr in the other five tables. Now in your perform screen you would have a label in the attributes like this: f000 = table1.person_nbr = table2.person_nbr = table3.person_nbr = table4.person_nbr = table5.person_nbr = table6.person_nbr; In your instructions, you'd have the following... table1 master of table2 table1 master of table3 table1 master of table4 table1 master of table5 table1 master of table6 The above is just a brief overview of what you want to do, check your manual about joining tables with perform. DAS -- David A. Snyder @ Snide Inc. - Folcroft, PA Current Release is db4glgen-3.4 UUCP: ..!uunet!das13!dave INTERNET: Dave.Snyder@snide.com