Retreiving data from another table

[RB86]

Hi,
I have a database with a data table (first table) that holds all records in
numerous fields including their seriel numbers.
I have also a created a order form linked to an order table(second table) in
the database that allows users to enter their name and seriel number of the
product they wish to order. Ofcourse those enteries go into the order
table(second table).
I want all the fields been automatically filled out in the order
table(second table) upon enteries of seriel numbers, from the data
table(first table) i.e based on exact match of their seriel numbers.
I have been trying to find methods for days, any help will be greatly
appreciated.
Thank You

 

[Kerry]

Don't have fields automatically filled out, instead use a query with
the two tables joined when you want information from both tables.

 

[RB86]

Thank you for your reply,
but I need the rest of fields automatically filled out in one table from
another based on seriel number field.
Thanks