Hmm, I actually do have the cascade delete option set, however, my relationships are a one to one type. Although, I took your advice and it seemed to have worked out.
Thank you!
~Kris
Anon93
Last Activity: Feb 6 '10, 10:12 PM
Joined: Feb 6 '10
Location:
-
Error 3086
I'm an IT student currently working on a database and I am required to perform a delete query. The database I am working on seems simple enough but the query simly wont run.
This is my SQL:
DELETE Payments.*, Sections.*, [Personal Information].*, [Personal Information].[ID Number]
FROM [Personal Information] INNER JOIN (Sections INNER JOIN Payments ON Sections.[ID Number] = Payments.[ID Number]) ON (Sections.[ID...
No activity results to display
Leave a comment: