The Underscore Archives

In my days building and maintaining Access databases, I got a taste for the
Excel-like table interface; cutting and pasting whole columns of data at
once, so typing in one record at a time into an online cms really gets on my
nerves!
Access not being very mac or mysql-friendly, I'm trying to recreate this
functionality for a big project that's coming up, using my photoblog
database to experiment on.
Here's where I'm at so far:
www.floppycat.com/paddyblog/new_uploader/styled_css_multipaste.php
I've handled the paste-able columns by putting rows into textareas, which
I'll have to separate out by using the line breaks when I do the submitting
stuff. (I'm still thinking about how (or whether) to allow deleting of rows
)
My current mission is to do some kind of JS autocomplete for some of the
<textarea> columns, but it'll have to work with a multi-line textarea, so
only autocompleting the text typed since the last line break, and of course
the suggestion box will have to appear somewhere near the text cursor
position. Any ideas? Is there already something out there like this?
Ideas/links appreciated. The final project will have a dozen or so tables
with quite a bit of cross-referencing.
- Paddy