Hi Guys,
         I am new to SQL.Could someone help me out.
Problem:
         Form A based on Table A.
         Sub-form B based on Table B.
         Table A and Table B are linked thru a key called "ProgramNo" .
Now based on the record accessed in Form A, I need to append a record from Table A to the sub-form/Table B.How do I do that.

How do i set up the criteria??An ideas

(The purpose is to do something like an autofill)