Hi, anyone have any reccomendations as to the best way to use ADO
in VB to take an object hierachy and save/restore it's structure and data
with a jet database?
I used DAO, and it was hard work, requiring index fields, and was
inflexible, and slow
now I heard about relational databases, relations, and stuff, and I wonder
is it possible for a jet record(in a table) to have a field that holds a
reference to another record in a different table.
Do I need to use the ADO class wizard somehow, or what?
it's like a many-to-many relationship for each record.
I guess I would expect one field to point to it's parent, then another to a
list of children , then the rest of the fields could hold the object's
private data values.
What I want to avoid is a field called ID, which is manually
cross-referenced to parent's children etc,
I could not see an option for such a reference in a jet field - there was
OLE object, hyperlink, but not 'record' (as well as number/text/etc)
say for example, you had a class called 'person', and used it to build a
family tree, where each object had 'name' and 'birthday'. How could you
store the data without using a unique field(such as 'name' or 'ID').
Nick Le feuvre B.Eng