BorlandTalk.com

Guest · Posted: Fri Apr 13, 2007 8:45 pm Post subject: searching for "exotic" dbgrid

I want to give my user opportuninty to create the following grid.

product 1 product 2 product 3 ...
(fixed row)
material 1
material 2
material 3
.....
(fixed column)

Where the names of the products and materials are taken at runtime
from tables that the user
can alter. The grid then must store the values of it's cell in a table
with the following stucture

product_id
material_id
value

The grid should be able to react to changes of the products and
material tables too.
For example if user deletes product1, it's column should disappear
from the table and the
coresponding records in the table to be deleted.

I tried to implement this behaviour with standard string grid and
almost succeeded doing that, but as a result I've got alot of
"spagetti code" which I start to mistrust, so I decided to spend some
time writing my own grid component. The only thing is that I want to
be sure that I'm not replicating something already done, which I could
use instead.
Any ideas please?