Recommendations on DB, structure, etc.

Why do you think it is kludgey? There are few things you can say about an application that are more complimentary then "it works". Excel is ubiquitous, well-known, and well-understood. Although there is always fun in creating a new solution, if your goal is to Get The Job Done, I'm not sure you'll be able to do better than what you have now.

It has been said many times that the number 1 database application in the entire world is Microsoft Excel.

···

On Wed, 23 Mar 2005 10:00:56 -0600, Clint Laskowski <clint@robotic.com> wrote:

If you're interested, the way I deal with this database right now is as follows: I have an Excel spreadsheet with the first five fields in columns. I use Excel's autofilter function to provide for sorting and filtering. The sixth column of the sheet contains a URL to a local text file (one for each record). When I click on that link, it opens the text file, where I can type description notes. It's kludgey, but it works. I dream of the day when I can have this functionality in one wxPython application!

--
- Tim Roberts, timr@probo.com
  Providenza & Boekelheide, Inc.

It's 'kludgey' because it requires two applications and hundreds of text files to store the description notes for each record.

-- Clint

Tim Roberts wrote:

···

Why do you think it is kludgey? There are few things you can say about an application that are more complimentary then "it works". Excel is ubiquitous, well-known, and well-understood. Although there is always fun in creating a new solution, if your goal is to Get The Job Done, I'm not sure you'll be able to do better than what you have now.

It has been said many times that the number 1 database application in the entire world is Microsoft Excel.