a form the shows information from another table

[jlydon]

I want to make a form for a library where I scan in the book barcode
and automatically it will show on some part of the form the name and
author of the book. Then I can scan in the student ID to check out
that book. Thanks for any guidance.