Hi all
For my training db, I have a CourseListT which contains CourseID and CourseName fields. I have another juntion table called Course_JT which has following fields:
When I press OK, the db deletes all records of CourseID 100 from Course_JT. Now it is a weird problem because the db is not setup to be multiuser. At the moment, I am the only one using/setting up the db.
Cheers for any help in advance.
For my training db, I have a CourseListT which contains CourseID and CourseName fields. I have another juntion table called Course_JT which has following fields:
- DeliverID (PK)
- CourseID (FK)
- ProviderID (FK)
- CertificationAuthorityID (FK)
- CourseCode
- TrainingLevel
- Cost
When I press OK, the db deletes all records of CourseID 100 from Course_JT. Now it is a weird problem because the db is not setup to be multiuser. At the moment, I am the only one using/setting up the db.
Cheers for any help in advance.