I use Visual Studio 2010 with VB.Net and Microsoft Access Database.I have form Loan and form Equipment. In form Equipment i have item Equipment ID, Equipment Item,Model,Description,Quantity,Serial No and Status. In form Loan i have Equipment ID, Name,Staff ID,Telephone No,Department Equipment Item,Date Loan,Date Return and Period. When user key in Equipment ID in form Loan the Equipment Item will be set automatic after key in all detail in form Equipment. Tq for helping.