Book Reserve / Check out buttons (1 Viewer)

[Cubsm22p]

Here I am working on a practice database doing a Library management System. I have an attached database (working on making test data for the tables will upload when finished). I am trying to figure out a way I can do the book checkout and book reserve buttons.


some thoughts i had on how to do it:
I have put a [ID] Label above the REserve Button, so when that reserve button is clicked this Sudo code should happen:
IF
Me.[ID] == (to any ID in the MEMBER table)
Then
(copy [ISBN] and [ID])
DoCmd.OpenForm "Reserve",acNormal, ,"[ISBN]" = (the copy) ,"[ID]"= (the copy)

Basically taking two Fields from the the current form and copying them to the next form

 

[Cubsm22p]

Also if a Member associated with that ID has over 6 books checked out then he cant check out anymore books so there would be a pop up message saying no more books, and only one book can be reserved at a time