Record Deleting

[XQuilet]

Hi and Greeting

I need some help with deleting of Record.

currently i have a form with subform datasheet

Form from Purchase order table
Subform from serial table(Brand,Model,Type,Location,Serial) with serialtrans table(InOut,AQty,Comment)
(SELECT tbl_Serial.*, tbl_SerialTrans.*
FROM tbl_Serial LEFT JOIN tbl_SerialTrans ON tbl_Serial.SerialID = tbl_SerialTrans.SerialID

when i click on the datasheet row and delete the row it only delete the record from tbl_SerialTrans but record on tbl_Serial was not deleted


is there any way to delete it?


Thanks in advance!

 

[HiTechCoach]

The way I prefer to do this is with a Delete button that runs VBA code to delete records from all the related tables with delete queries.

If you are really feeling lucky

***** Make sure you make a backup before proceeding******

you could try turning on cascading deletes for the relationship.

***** Make sure you make a backup before testing******

FWIW: I NEVER use cascading deletes. I have seen it lead to mass amounts of data getting lost.

 

[GohDiamond]

ECHO THAT:
***** Make sure you make a backup before proceeding******

***** Make sure you make a backup before testing******


File\SaveAs\ADVANCED\Backup Database

Cheers!
Goh

 

[HiTechCoach]

File\SaveAs\ADVANCED\Backup Database

That only gets the front end if the database has been properly split.

You must back up the tables in the back end!

I will not work on a database that is not split. Why? See my thoughts here:

Splitting your Access database into application and data