Need Help Building a small database

[Darren]

I started building a database that tracks the maintenance on scanners. I have two tables, one that includes the scanner's SN, Comp. Name it is attached to, Model #, and Department location. Another table that includes the date of the recorded problem, the Work Order ID# and the submitter.
I was wanting to be able to click on one of the scanners and have that open it's own recorded problem table so it can have the data added to it.
Is this possible and how should I go about setting this up or at least something similar.

[June7]

Consider form/subform arrangement. Main form bound to scanner info table, subform bound to work order table. Build search/filter of scanner SN into main form. Check out this tutorial http://datapigtechnologies.com/flash...tomfilter.html

Or have a workorder form, open to new record, select scanner SN from combobox.