Posted on: 4/8/2011 12:04:31 PM | Views : 501

Hi! I have this problem editing records from muliple tables.
I have three tables:
TblBooks,
TblCategory
and BookStatus.
 
TblBooks has foreign keys from TblCategory and BookStatus (like category name and statusname like if the book is 'Out' or 'Reserved')
So far I can add records from multiple tables using a custom formsview but how can I edit them? Looks like I have to messed up some SQL Select statement.
 
...

Go to the complete details ...