June7
AWF VIP
- Local time
- Today, 04:06
- Joined
- Mar 9, 2014
- Messages
- 5,601
DB is not using autonumber keys. They are all text: BookNumber, Surname_Name, Grade, etc. Using a name as key is guaranteed to fail.
Should have an ID field as key in Books table and save that into BookNumber, not BookTitle. Similarly for student identifier, save an ID key, not name.
Relationships window shows BookNumber table joined twice to LearnerBookIssue table. They are joining on key fields which is then a one-to-one relationship.
You might look at the MS Access Lending Library database template. https://support.microsoft.com/en-us...emplates-e14f25e4-78b6-41de-8278-1afcfc91a9cb
Should have an ID field as key in Books table and save that into BookNumber, not BookTitle. Similarly for student identifier, save an ID key, not name.
Relationships window shows BookNumber table joined twice to LearnerBookIssue table. They are joining on key fields which is then a one-to-one relationship.
You might look at the MS Access Lending Library database template. https://support.microsoft.com/en-us...emplates-e14f25e4-78b6-41de-8278-1afcfc91a9cb
Last edited:
