Guest_imported
New member
- Jan 1, 1970
- 0
Hi!
Three tables.
Customer primary key to Orders sekundary index
Supplier primary key OneToMany Orders sekundary index
Reference delete rules between Suplier and Orders.
When I try deleting a supplier I whant all Orders with this supplier Id also to be deleted but it doesn't delete either the selected supplier och the matching records in Orders? The smaple I use is from Access helpfile. What goes wrong here, is it the connection to Customer table from Orders or what??
I'm used to other databses e.i Paradox, Dbase a.s.o. and in them I usually program my function/procedures self, in this case I either loop my way through the records or use SQL for handling this event, but Accesshelpfile tell's that deleting records i two tables with OneToMany connection could be performed with an allredy excisting macro?
MVH
Rune
Three tables.
Customer primary key to Orders sekundary index
Supplier primary key OneToMany Orders sekundary index
Reference delete rules between Suplier and Orders.
When I try deleting a supplier I whant all Orders with this supplier Id also to be deleted but it doesn't delete either the selected supplier och the matching records in Orders? The smaple I use is from Access helpfile. What goes wrong here, is it the connection to Customer table from Orders or what??
I'm used to other databses e.i Paradox, Dbase a.s.o. and in them I usually program my function/procedures self, in this case I either loop my way through the records or use SQL for handling this event, but Accesshelpfile tell's that deleting records i two tables with OneToMany connection could be performed with an allredy excisting macro?
MVH
Rune
