Creating an Entry Form

[Bike]

Looking for a little bit of help from a more experienced access user. Excuse my terms and everything because i am rather new to access. I am creating a database for a class project that deals with car sales / repairs.

The main table i created has all the information about the car:
( [PKey]serial #, make, model, warranty expiry date etc. )

The second table is to keep track of all of the repairs which contains the:
( [PKey]invoice #, serial #, mechanic's name, description of work, etc. )

What i am trying to create on my Repair Entry Form is that when i type in the cars Serial # at the top of form, it will pull up the warranty information below so that it is an easier way to tell if the customer will be charged or not.

I am not asking for some sort of step by step instruction, but rather looking for guidance on which options i should be looking into to or the direction I should be heading in.



Any help is well appreciated.

[pbaldy]

This help?

http://www.baldyweb.com/Autofill.htm