Delete multiple records and files?
Hi
Im am trying to work out how to use DB to solve this:
Two database tables:
TableA:
ID
description
TableB:
ID
Thelink (Same as TableA ID)
Imagename (associated image is on server)
If I want to delete TableA record 50 how would I use DB to delete the record from TableA and ALL assocated records from TableB and finally the image files named in each TableB record there could be various amounts linked to a record in TableA.
Im assuming this is possible using Db just not sure how to start.
Thanks
Mike