Cascades and Object Data Tables -- delete a text to delete other texts

[matt_1ca]

I have created a program that pumps three texts into a drawing.

At the time that it pumps those texts, the first text gets attached to an object data table and given some information.

When the user erases the first text -- I want to be able to erase the other two texts with it automatically.

I think I could do this by storing the objectID of the the other two texts together with the other information that is attached to the first text (hence two additional fields in the object data each corresponding to the objectid of each of those two texts).

When erase command is issued for the first text -- a routine would be triggered to erase the objects corresponding to the object ids in the two added fields.

I can do that but do not know if this is the best way of doing it -- I am thinking maybe there is some other more
elegant way of doing it -- by say for example creating relationships between object data tables? I havent tried creating relationships between odtables I do not even know if that is possible.

In MS Access something similar to this can be done using cascades A record if deleted from one table that is related to another can be made to delete all other information related to it in the other tables so that referential integrity is maintained.

Thank you so much for all the kind help you can give.

Matt

[matt_1ca]

Thanks Scott,

I will give it a try.

Matt