I am a new programmer.

I have created a table called "tblOrder" and "tblTransaction" in Microsoft Access. The relation between them is one to many.

I am creating an entry in tblTransaction only when I create tblOrder's entry.

So 1 Order can have multiple transaction.

Now I want to find a field called "remain_balance" from table "tblTransaction" such that its orderid is '12' and the balance is minimum among all the entries.

Please help Me!!!!