Creating a record with a foreign Key
I must be tired today, because I can't remember how to do something basic.
I have Two Tables
I want to create a form for creating new records in Table B that allows people to type in the number and use a drop down to select the Names from Table A and then automatically populate Table B with the matching Key A1.
This seems so basic to me, but right now I am drawing a blank.