depend on select

Archived from the Library DB Discussion forum.

antoniussony — Sun Oct 12, 2008 6:38 am

hii, i’ll try develop my library using your application

i already make borrow_table (contain userid, username, bookid, borrowdate, title, return) and return_table (contain userid, username, bookid, title, borrowdate, returndate, fee)

for borrow_table :

if click on bookid (select type) automatically it show title

for return_table :

if click on userid automatically show bookid, title and borrowdate from borrow_table

aftergive value returndate(date widget) automatically give value = returndate - borrowdate to fee

after click save automatically give value Y to return on borrow_table

thank’s