Hello

I really really want to use SQLNotes because I can see that it does a majority of the data management tasks that I need.  However, I can't figure out how to do specific things:

1.  Tree/Grid of Grids

The hierarchical grid is great!  But in addition to each grid node linking to a gant chart, html document, etc, I need a definable grid as a node's document type a la InfoStore from MHSoftware.  Is there a way to do this already?  Visualize a tree panel on the left, with some nodes linking to html documents, some to forms, some to gants, and some nodes linking each to "their own" definable grids (or tables, in industry parlance).  That way I could easily group individual grids according to an hierarchical logic.

An HTML table doesn't cut the mustard for me.

2. Designation of Foreign Keys.

Is this already possible?  For instance, in a parent grid, designate a unique key field.  In a related/subordinate grid, designate a foreign key and declare referential integrity between the two.  Ideally, the display control for the foreign key on the subordinate grid would be a combo box linking to a (unique) list of the primary key values of the parent grid.

InfoStore doesn't do the linked combobox/primary/foreign key thing, but perhaps SQLNotes can (or might in the future?).

MS Access allows me to do this, of course, but the SQLNotes interface is so nice and has a so much lower overhead, I'd prefer not to re-invent the wheel if possible.  Besides, implementing trees in Access is a real pain.

Maybe this stuff is already in SQLNotes and I'm just slow to find it?

Thanks for listening!

I just want to say thanks for such a great program.  Over the years there have been a few programs that have stood out as historically significant (for me, at least).  TC, Keynote, a few others.  Screenshot Captor is equally important to me as those other utilities.  A significantly useful tool, well-designed.

Thank you.