Hi,
What is considered the best way to do the following? Any practical help will be greatly appreciated in this area, if I can do the following, I have my app licked! I have not read the Xbasic or Xdialog PDFs yet - for some reason everytime I try my system crashes (with ANY PDF). So, I am struggling to get this working smoothly.
I am busy with a library app. I have tblBooks (a list of books) and tblMembers (a list of members) and a set setBookMember of these tables.
On the "Issue Book" form (based on setBookMember) I have two fields, book_id and book_title. When a book is being issued, the user must be able to fill in EITHER field, and upon clicking a button, the other is completed (for confirmation purposes). (in case of error, I have a message box saying so).
At that point, the user performs exactly the same type of lookup procedure for members, using either the member_id or the member_surname field. Naturally, the user must be able to search for a particular member in the case that there are multiple members with the same surname.(in case of error, I have a message box saying so).
Then, the "Issue Book" button becomes active. When pushed, the member_id is copied into a member_id field in tblBook in the appropriate book's record, and the field number_books is incremented by one in tblMember.
Okay - am I correct in using the set for this form? How do I update the tblBook and tblMember tables? Or do I just update the set? Any help appreciated...
Regards,
Evan
What is considered the best way to do the following? Any practical help will be greatly appreciated in this area, if I can do the following, I have my app licked! I have not read the Xbasic or Xdialog PDFs yet - for some reason everytime I try my system crashes (with ANY PDF). So, I am struggling to get this working smoothly.
I am busy with a library app. I have tblBooks (a list of books) and tblMembers (a list of members) and a set setBookMember of these tables.
On the "Issue Book" form (based on setBookMember) I have two fields, book_id and book_title. When a book is being issued, the user must be able to fill in EITHER field, and upon clicking a button, the other is completed (for confirmation purposes). (in case of error, I have a message box saying so).
At that point, the user performs exactly the same type of lookup procedure for members, using either the member_id or the member_surname field. Naturally, the user must be able to search for a particular member in the case that there are multiple members with the same surname.(in case of error, I have a message box saying so).
Then, the "Issue Book" button becomes active. When pushed, the member_id is copied into a member_id field in tblBook in the appropriate book's record, and the field number_books is incremented by one in tblMember.
Okay - am I correct in using the set for this form? How do I update the tblBook and tblMember tables? Or do I just update the set? Any help appreciated...
Regards,
Evan
Comment