Joining objects in tablemaker

Article View: bionet.software.acedb

Article #62

Back to bionet.software.acedb Previous Next

#62

From: "Brandon Walts"
Date: Fri, 05 Sep 2003 08:34

20 lines
2647 bytes

Hi-

I'm wondering if it's possible to join two objects using a common key
tablemaker, similar to joining two tables in a relational database.

For example, let's say I have a Locus, and that Locus refers to
Positional Candidates, which in turn contain Phenotypes.  Is it possible
in tablemaker to display the loci (from the Locus objects) and the
associated Phenotypes (from the Positional Candidate objects) in the
same table by somehow following the reference from a Locus object to the
appropriate Positional Candidate objects?

I haven't found a way to do this, and the documentation at acedb.org is
spotty on the issue, so I'm guessing that it's impossible, but I wanted
to verify this with the experts here before giving up.

Thanks in advance

-Brandon
---

Technical Details

Message-ID: <sf576212.011@mhs.pbrc.edu>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!bloom-beacon.mit.edu!hgmp.mrc.ac.uk!net.bio.net

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f6d40,c5b68deac5abed,start
X-Google-Attributes: gidf6d40,public
X-Google-ArrivalTime: 2003-09-05 01:34:14 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!bloom-beacon.mit.edu!hgmp.mrc.ac.uk!net.bio.net
From: WaltsBM@pbrc.edu ("Brandon Walts")
Newsgroups: bionet.software.acedb
Subject: Joining objects in tablemaker
Date: 5 Sep 2003 09:34:12 +0100
Organization: BIOSCI/MRC Human Genome Mapping Project Resource Centre
Lines: 21
Sender: mod-ace@hgmp.mrc.ac.uk
Approved: BIOSCI Approval Key <biosci-approval-key@net.bio.net>
Message-ID: <sf576212.011@mhs.pbrc.edu>
NNTP-Posting-Host: mercury.hgmp.mrc.ac.uk
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-Trace: niobium.hgmp.mrc.ac.uk 1062750853 9687 193.62.192.80 (5 Sep 2003 08:34:13 GMT)
X-Complaints-To: news@net.bio.net
NNTP-Posting-Date: Fri, 5 Sep 2003 08:34:13 +0000 (UTC)
X-Original-To: bionet-software-acedb@net.bio.net
Content-Disposition: inline
X-Original-To: acedb@net.bio.net
X-Received: from localhost (localhost [127.0.0.1])
 by mercury.hgmp.mrc.ac.uk (Postfix) with ESMTP id 3690F7D2B5
 for <acedb@net.bio.net>; Thu,  4 Sep 2003 22:02:29 +0100 (BST)
X-Received: from mhs.pbrc.edu (mhs.pbrc.edu [198.62.89.252])
 by mercury.hgmp.mrc.ac.uk (Postfix) with ESMTP id C41DB7D2A7
 for <acedb@net.bio.net>; Thu,  4 Sep 2003 22:02:27 +0100 (BST)
X-Received: from Domain-MTA by mhs.pbrc.edu
 with Novell_GroupWise; Thu, 04 Sep 2003 16:02:26 -0500
X-To: <acedb@net.bio.net>
X-Auth: PGPMoose V1.1 PGP bionet.software.acedb
 iQCVAwUAP1hKhKCIqsWvyF5FAQEdGAQAknqJPwQXCsBr9unwT8W4PUBOxlXj9yNP
 UtNJX1WmhyjYo6Z2C/H+8TSZXsltXnZhaUs2aiMC+GPbuemZyywOqa1n7X8E7FB2
 gU5xB3W3pstu+dO60igwCx7sRnyG3dSAT/PkLvBYFVv520+kYZRpQjrKOmQgs5XW
 pJ5aBOfBYdA=
 =YqDB