Hello. I am a fan and user of MS Access but not a programmer. Please excuse my limitations. Can you please help me with a goal from the following information?
Background - I have created a database that I use as a health assessment for individuals. Demographic data is entered in advance of the assessment. Then, participant data is entered into these 5 tables with a relationship established by their personal id: Personal, heart health, diabetes, weight, stress self-care. After the assessment day is complete, I securely store the records created and then delete records where no data was collected, identified by null values in heart health table. Due to my limited knowledge, I do this by deleting data based on personal id in all tables. I cannot simply delete the personal table with cascading delete across all tables due to the relationship established (referential integrity?) along with default table value that are entered when a record is created.
Goal - Delete all records by personal id in a single query or other method. I am tinkering with my first delete query with no success. My current version includes all related tables by heart health fields (to establish null) and the * for the other tables. I have previously tried including all fields from all tables without success. I suspect my problem may be an easier fix for the folks like you in this forum that are much smarter than me.
You can find a screenshot of the query by following this link, https://i.imgur.com/CPc81NF.png
Please let me know if you can help. I would really appreciate it. Thank you.
Best Regards,
Scott