Article View: comp.sys.mac.databases
Article #3744D: Layout ???s
From: William Matthew Beaver
Date: Thu, 05 Nov 1992 21:38
Date: Thu, 05 Nov 1992 21:38
38 lines
1785 bytes
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