I am build an application that I can use to keep track of my company's hardware.  I have a New Hardware form for adding new entries, an All Hardware form/report, and a Check Out/In form to perform the check-out/in action.  

I have a couple of basic questions I need help with:

• When a "New Hardware" form is submitted, is there a script I can implement to create a new entry in "All Hardware" and copy values over?
• Is there a way that in the "Check Out/In Form" I can use a Single Line field with a barcode input to look up a barcode in the "All Hardware" form and edit its values?