Hi folks.
My project has 2 tables:
tblBook - ISBN [primary key], Title, Author, Year, Publisher, Total
tblAcc - AccNo [primary key], ISBN [foreign key], Status (combo box),
Borrow (check box)
Example:
tblBook
013089592X | ... |... |... | ... | 3
0131103628 | ... |... |... | ... | 2
tblAcc
M0200 | 013089592X | On Shelf | ...
M0201 | 013089592X | On Shelf | ...
M0202 | 013089592X | On Shelf | ...
M0203 | 0131103628 | On Shelf | ...
M0204 | 0131103628 | On Shelf | ...
I am suppose to allow the user to import an Excel spreadsheet into
tblBook, which I have done successfully. However, my problem is that I
have to update tblAcc, and I prefer to automate this process if
possible, but I don't know how. AccNo is suppose to be an incrementing
number. My idea was:
1) the user types in the details of the book into the Excel
spreadsheet.
2) the user imports the spreadsheet into tblBook.
3) tblAcc will use Total in tblBook to generate / auto-increment AccNo
and fill in the rest of the details (i.e. copy the number of ISBN
based on Total, set Status to "On Shelf", set Borrow to false)
Numbers (1) and (2) works, but I am unable to do (3). Can anyone give
me any pointers and ideas on how to achieve this? Or is there a better
way? Thanks in advance.