Deleting from related tables VB.NET Compact Framework

ross_may

Member
Joined
Nov 20, 2004
Messages
6
Programming Experience
1-3
Hi all,

I have a database with 3 related tables;

job_sheet (PK job_number)
material_lookup_table (PK material_lookup_id, FK job_number)
labour_lookup_table (PK labour_lookup_id, FK job_number)

For each job_sheet record, there can be multiple material and labour records....

In Vb.NET (Compact Framework), is it possible to remove all the related records with one call or do I have to manually code it to delete each related record from each table?

Thanks for you help,
ross_may
 
Top Bottom