Xref: utzoo comp.sys.ibm.pc.misc:2816 misc.wanted:11684
Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!sdd.hp.com!elroy.jpl.nasa.gov!news
From: cyamamot@kilroy.jpl.nasa.gov (Cliff Yamamoto)
Newsgroups: comp.sys.ibm.pc.misc,misc.wanted
Subject: Is there a spreadsheet/database combo program?
Keywords: spread sheet, database, linked, lotus, dbase
Message-ID: <1990Oct19.032936.6557@elroy.jpl.nasa.gov>
Date: 19 Oct 90 03:29:36 GMT
Sender: news@elroy.jpl.nasa.gov (Usenet)
Organization: Jet Propulsion Laboratory, Pasadena, CA
Lines: 28
Originator: cyamamot@kilroy
Nntp-Posting-Host: kilroy.jpl.nasa.gov

Greetings,

I'm sure a program like this must exists since it would seem to be
useful for so many applications.

I'd like to find a way to import or link database entries with entries
in a spreadsheet (Lotus/Excel/whatever doesn't matter).  What I'm looking
for a way of searching for a item in a database (w/ some predicate), then
once the entry or entries have been found, bring it's values into the
spreadsheet.

*THEN* if I change a value in the spreadsheet which affects the values
for one of my spreadsheet entries, it's new updated value is reflected
in the database respectively.

If this isn't possible, it would be nice to at least have some sort of
programmable macro that performed a database operation (query/sort/etc.)
whenever a particular spreadsheet operation was performed.

Is this too far fetched?  I'd prefer something on the IBM/PC platform but
I guess Macs would be ok.  This doesn't have a be a full fledge product.
It could be some add-on program to an existing database and/or spreadsheet
program.

Any pointers would be appreciated!  I'll summarize if there is sufficient
interest.

Cliff Yamamoto