auto populate a field

[ren086]

Hi All, I am trying to build a very simple database to be used for a school library. I have built all the tables however I am now stuck when trying to build the final table to record the book lendings. I put the concept simple ... I have 2 tables, a students table and a books table. Both of them have 2 columns each namely student ID and student name while the books table has book id and book name.

When I come to the lendings table, I would like to have 4 columns. Student ID / Student Name / Book ID / Book Name



I have set both Student ID and Book ID to be a combobox using looking from their respective tables and till there it is fine.

I would like to auto populate Student Name and Book Name from the IDs I have chosen from the respective comboboxes. Instead of writing them manually inorder to avoid having mismatched data. Is it possible that someone guide me how to complete this simple task please. Thanks.

[ranman256]

you dont use 4 columns, you want:
Student ID / Book ID /

then in a query you join tLending table to both tStudents and tBooks to get the names.

Make a form, put in a combo box for students. (bound to StudentID()
and a combo for books, (bound to BookID)
add a button to 'Lend"
this runs an append query to add the 2 IDs to the tLend table.
docmd.Openquery "qaLendBook"

choose a student,
choose a book,
click Lend button.

this query looks like:
insert into tLend (StudentID, BookID) values (forms!myForm!cboStudent,forms!myForm!cboBook)

you may also want to add a LendDate field to the tLend table:
LendDate (default to Date() )
DateReturn

[ssanfu]

You might look at the Database Answers site.

In the center list, under " 1. Customers", scroll down to "11. Libraries".
There are 16 Library models available to look at.