Hi everyone, I'm relatively new with access so please bare with me.....
I was able to incorporate a repeatable checklist that I found on YouTube called "Adding a Checklist from MS Data" for my database I created. For the Master ID that was set I named it "AudID" from the tblMaster.
The code works fine, however I am trying to create a relationship with the AudID to the tblData. When I tried to create the relationship the code completely stops working and would not duplicate the checklist anymore.
What I am trying to do is create an audit checklist. the checklist will have the
dataID, dataLinkID (which copies the AudID), dataset (set to 1 so it repeats), dataItem, Status (lookup to a list with "Good,"NA", "NG" status), Notes so that the auditor can apply to the notes.
The reason why I was trying to create a relationship from the relationship table is to have the ref. integrity so that if for some reason the auditor originally puts the wrong Audit ID number the first time, they can change it and all the data that was in the old AuditID will be changed as well to the new one.
I noticed from the current codes from the video is when I change the AudID number, it will repeat another 33 list of items (that's the checklist) for that new AudID number AND the old AudID # will still be in the tbldata list.
Again the only thing I changed was adding the 1 to many relationship to have ref. integrity.
Hope someone can help!
I was able to incorporate a repeatable checklist that I found on YouTube called "Adding a Checklist from MS Data" for my database I created. For the Master ID that was set I named it "AudID" from the tblMaster.
The code works fine, however I am trying to create a relationship with the AudID to the tblData. When I tried to create the relationship the code completely stops working and would not duplicate the checklist anymore.
What I am trying to do is create an audit checklist. the checklist will have the
dataID, dataLinkID (which copies the AudID), dataset (set to 1 so it repeats), dataItem, Status (lookup to a list with "Good,"NA", "NG" status), Notes so that the auditor can apply to the notes.
The reason why I was trying to create a relationship from the relationship table is to have the ref. integrity so that if for some reason the auditor originally puts the wrong Audit ID number the first time, they can change it and all the data that was in the old AuditID will be changed as well to the new one.
I noticed from the current codes from the video is when I change the AudID number, it will repeat another 33 list of items (that's the checklist) for that new AudID number AND the old AudID # will still be in the tbldata list.
Again the only thing I changed was adding the 1 to many relationship to have ref. integrity.
Hope someone can help!
