Xref: utzoo comp.sys.ibm.pc:54488 comp.sys.ibm.pc.misc:2839 misc.wanted:11695
Path: utzoo!utgpu!watserv1!watmath!att!drutx!druwa!rlp
From: rlp@druwa.ATT.COM (PrehnRL)
Newsgroups: comp.sys.ibm.pc,comp.sys.ibm.pc.misc,misc.wanted
Subject: Re: Is there a spreadsheet/database combo program?
Summary: Try Microsoft Works (<$100)
Keywords: spread sheet, database, linked, lotus, dbase
Message-ID: <6389@drutx.ATT.COM>
Date: 19 Oct 90 14:49:32 GMT
References: <1990Oct19.032936.6557@elroy.jpl.nasa.gov>
Sender: news@drutx.ATT.COM
Reply-To: X@druwa.ATT.COM
Organization: AT&T Bell Laboratories, Denver
Lines: 31

In article <1990Oct19.032936.6557@elroy.jpl.nasa.gov>, cyamamot@kilroy.jpl.nasa.gov (Cliff Yamamoto) writes:
> 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.
> 
> Cliff Yamamoto

I don't have the documentation here & don't use spreadsheets but here is my
$.02 worth.  I belive you can grab data from the integrated database into a
spreadsheet.  I vaguely remember seeing macro commands for that while
browsing thru the manual.
It has a built in spreadsheet compatable with MS Excel & MS Multiplan &
Lotus 1-2-3 1A & 2.x spreadsheets.
It also has a built-in word-processor with spell checker & thesaurus,
and electronic communications.
The database allows you to create & store custom forms & reports.

Bob Prehn