Autofill and some other problems

[Ibnul Ahsan Mayukh]

I am currently working on building a database for a school library using an access database. in terms of expertise i probably am an novice. so i have built the database and all the tables. two table for books(one with ISBN as primary key[containing
- ISBN (Text/String, 13 characters), BookName (text/string, 100 characters), Author (text/string, 50 characters ), Publisher ( text/string, 50 character), Genre (text/string, 50 character), Price (currency, 10 characters), date published (Date/time, Short date), number in stock (Text/String, 5 characters)] and one with Book ID as Primary Feld [containing bookID(text/striing, 11 characters), date added (Date/time, Short date), ISBN (Text/String, 13 characters)], two tables for database wth a similiar strusture. two table for members{student and staff}. both has:

- MemberID (number, 10 characters), memberName (text/string, 50 characters), student (yes/no), [class, roll, section] (text/string, 25 characters), Room no. (text/string, 10 characters), contact number( text/string, 50 characters ), e-mail (text/string, 50 characters), address( text/string, 75 characters) there is two loans field. one for book loans and one or products with similir strucure of

[FONT=&quot]LoanID(text/striing, 11 characters), LoanTime(Date/time, long time and short date), BookID/ product ID(text/string, 11 characters), ISBN/Barcode number (Text/String, 13 characters), BookName/ ProductName (text/string, 100 characters),[/FONT][FONT=&quot]Author/ Manufacturer (text/string, 50 characters), MemberID(text/striing, 11 characters), ), MemberName (Text/String, 50 characters), student (yes/no), (Class, section, roll) (Text/String, 5 characters), room(Text/String, 6 characters), return Date (Date/time, long time and short date), Extension (Date/time, long time and short date), Fine(Text/String, 6 characters)[/FONT]

mostly everything works perfectly except one big hurdle. i want the fields regarding book info(ISBN, Bok in books table and product info in product table. i want the ISBN to be filled automatically from book table with BookID, whic will automaticall fill rest of the information about he book. also when i input memberID i want the member information to be fiiled automatically.this should happen in a form. i also want access to calculate the date of return ehich is exactly a week away. i also want it to calculate the fine. i also need help to create a report or all the loans of that week.

 

[Uncle Gizmo]

It's not a good idea to have data from one table moved into another table. A better idea is to link to the identity key of the table data and then show the information as and when required.