0

From my Previous question

What I want to do is to add a new student loan and the program checks the book title if loan exists, does not allow the same loan to be created. There is no limit on the number of loan placed by the student.

How do I write the code as above in VB.NET

Note: 1 book Per Loan number

Add Loan Form Add Loan form

Community
  • 1
  • 1
CompleteNewb
  • 125
  • 1
  • 3
  • 12

1 Answers1

0

I assume LoanID is also an auto-incrementing number? If not, it should be and then also make it a primary key.

Also, the Book record will want an auto-incrementing primary key field and then you can link the two record by id, and check the book_id (or similar) in the loan table for a particular student.

twilson
  • 2,062
  • 14
  • 19