🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.mac.databases
Article #374

4D: Layout ???s

#374
From: William Matthew Beaver
Date: Thu, 05 Nov 1992 21:38
38 lines
1785 bytes
I am trying to take a list of records, display them in a column format,
and create a new record in another table given whatever the user
selects.  For example:

Customer Table
Name            ID Number
--------------------------
Smith            9457
Jones            0982
Murphy           3920
   .               .
   .               .
etc               etc


When the user selects "Jones" that record is selected.  Then I want to
create a record in a table [Projects] related by ID number. I want the
input layout for [Projects] to come up immediately after the user double
clicks in the [Customer] table layout. With the ID number inserted (as
it sometimes does with the relation)

I think the problem lies in the fact that I'm trying to switch between
files. I've tried selecting all the names and ID numbers into arrays
with: 

selection into array([Customer]Cust_Name;AreaA;[Customer]Cust_ID;AreaB)

And then displaying the arrray with:  modify selection([Customer])

This is getting pretty ugly. Does anyone have any ideas as to how I can
do this? Either with the file switching or with the arrays? Another
(easier?) way.

ANY ideas would be greatly appreciated.

Thanks in advance,
William M. Beaver
Carnegie Mellon University
Technical Details
Message-ID: <QeyNFVq00UhW85rJ5K@andrew.cmu.edu>
Path: arc1-ca.pugleaf.net!sparky!uunet!portal!lll-winken!cert!netnews.upenn.edu!dsinc!cs.widener.edu!hela.iti.org!usc!zaphod.mps.ohio-state.edu!cis.ohio-state.edu!news.sei.cmu.edu!fs7.ece.cmu.edu!crabapple.srv.cs.cmu.edu!andrew.cmu.edu!wb1o+

Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!sparky!uunet!portal!lll-winken!cert!netnews.upenn.edu!dsinc!cs.widener.edu!hela.iti.org!usc!zaphod.mps.ohio-state.edu!cis.ohio-state.edu!news.sei.cmu.edu!fs7.ece.cmu.edu!crabapple.srv.cs.cmu.edu!andrew.cmu.edu!wb1o+
From: wb1o+@andrew.cmu.edu (William Matthew Beaver)
Newsgroups: comp.sys.mac.databases
Subject: 4D: Layout ???s
Message-ID: <QeyNFVq00UhW85rJ5K@andrew.cmu.edu>
Date: 5 Nov 92 21:38:41 GMT
Organization: Senior, Social & Decision Sciences, Carnegie Mellon, Pittsburgh, PA
Lines: 38