Linked Tables

[sdh]

Thanks to jmarler I have speeded up my importing of data
to my app using a linked table

just need to know however how once i have the link
can i carry out any of the following
-delete the link
-refresh the link
-index the link

thanks
in advance

 

[chiph]

There is no need to delete, refresh, update, etc. the relationship you have established between tables once it's been set up.

When you have a relationship, you need to insert the parent row first, so that when you insert the child (dependent) rows, they'll have something to link to. The reverse applies when you delete a row -- you must delete the child rows before deleting the parent, otherwise you get an error (because you would be orphaning the children)

After inserting your data, the relationship allows you to navigate from one to another. ie. Given a parent, find all it's children. And... Given a child, find it's parent.

Chip H.