Getting information from other table basing on typed cat no.

[Guest]

I have two tables: one is a list of materials with cat number, description of
material and price. Second table is my purchase order. I'd like to type a cat
no on my purchase order and get the rest of information (descr and price) in
next columns automatically from materials list.
Please help me...

 

[Guest]

What are you wanting to do with the information? If you just want to see it
then

1) Ensure there is a relationship between the two tables (between cat no,
I'm guessing)

2) Make a new query

3) Add your 2 tables

4) Bring down all the material fields you want (for fields you want to see,
leave the checkbox ticked)

5) Bring down the cat no from purchase order table

6) For its criteria, put [Please enter cat no]

7) Run the query (! button)

 

[Guest]

Actually, each purchase order will be one record in database. I need to get
those information from material list by typing just cat no. and save them in
purchase order table as one record. The table would look like:

no Mat code Mat descryption Unit
Qty
1 CBL.EMC.1.5 'to be filled from mat list' 'to be filled..'
100
2 TER.F.1.5 'to be filled from mat list' 'to be filled..'
50
3 ......
4 ......
I know how to do the query: I've made relationship and got the query with
all information I need. Now: how to send it to the current record in Purchase
Or. table and save? I'm going to use form so maybe there's way to use macro
to copy the query and paste into my table?