Hi guys ,
I need some advice in this.
I have kind of library where students can borrow books.
I have a tables tbllBooks with columns bId, bName, bNr,studentFK
tblStudenst with columns sID,sName,sNumber,startDate,endDate.
I need to to display every student hoe borrowed a book for example if book is borrowed from December's 2 till 6 December I need to show a line of those 4 days see example
Did someone had experience in building something like this any idea will be welcome
Thanx in advance