newbie for forms needs help plz

[elkidogz]

ok, so I have an inventory database that I've been prepping for use, and I am getting close. this inventory database is for 3 warehouses IT gear. It will store all warranty coverage, all purchases, all serial numbers for all gear, and all the repair orders for each device.

to that end, I have made a form for the repairs. The serial number table and Repair table have a one to many relationship (one serial to many repairs ) the Repairs table has the field coverageID as does the serial number table. they also have a model number field. What I would like to have happen is when the user enters in a serial number onto the form for the repairs table, the form then populates the model number and coverageID value from the serial number table onto the form input text.




So, the problem is that I have no idea how to do this. I can do selects for lookups and I've tried to do that, but I can't get it to pull the value in when the user gets the serial number value. please help.

[elkidogz]

Here is a pic of my relationships for this db.

[June7]

I am confused. The controls labeled ModelNumberTrans and ContractID correspond to fields in Repairs table, not SerialNumber table. Selecting a new value in SerialNumberTrans will not change values of other fields. Which fields in SerialNumber table contain this data? If data is in SerialNumber table why duplicated in Repairs table?