AnsweredAssumed Answered

Creating a record with a foreign Key

Question asked by MrMLK on Aug 6, 2013
Latest reply on Aug 6, 2013 by philmodjunk


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

     Table A



     Key A1                    


          Table B



          Key B1

          Key A1


     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.