Hello. I am trying to create a relationship between all the tables but some cannot maintain integrity, even though entries exist in both tables. For example linking ENTRY of both symbolnodes to symboltext returns unique index error. They are indexed with duplicates ok.
Lets say I want to delete all records from the class 'Alternator' in the table SymbolData. Now each record has LPNTR column which is the identifier or Entry column in the other tables. I want it so if I delete lets say ALT in SymbolData, using the LPNTR of ALT, the corresponding records in the remaining tables to be deleted as well.
Thanks. I appreciate the help.
Lets say I want to delete all records from the class 'Alternator' in the table SymbolData. Now each record has LPNTR column which is the identifier or Entry column in the other tables. I want it so if I delete lets say ALT in SymbolData, using the LPNTR of ALT, the corresponding records in the remaining tables to be deleted as well.
Thanks. I appreciate the help.