Help in appending a single record.
I am new to SQL.Could someone help me out.
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)