I want to be able to 'navigate' the relationships in an access database using LabVIEW.
Why do I want to do this?
I have a weird database design were primary tables with autonumber IDs are seperated with intermediate translation tables that do not have primary keys. So table A has autonumber IDs. These point to table B in a 1 to many relationship. Table C has autonumber IDs. These point to table B in a 1 to many relationship. So two tables with a 1 (Unique IDs) point to a intermediate table where all the columns are non uniques. (Both table A and C are on the 1 side of the 1 to many relationship.
A 1----Many B Many----1 C
Now take this ugly structure and multiply by ten where C points to e through d etc, etc, ad naseum.
Now I want to delete A and it's related records in C. But I can't just delete the primary key record. This will kill the middle table relationship (becuase of the 1 to many) and I will have a record in table C just floating.
So what I want to do is have code that can follow the relationships and delete the records in the proper order. Can this be done programitically through LabVIEW?
I can't change the design of the database. It is what it is.
Thanks!
