Can I use API_DoQuery to automatically relate records to different parents?

Hi,  I have a table called ORDERS. When an order is created I want the system to find a record from a separate table, RATES, which matches the values of several fields from that order. I then want ...