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

Title

Creating a record with a foreign Key

Post

     I must be tired today, because I can't remember how to do something basic.

     I have Two Tables

     Table A

     ----------      

     Name                       

     Key A1                    

      

          Table B

          ----------

          Number  

          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.

      

     Thanks.

Outcomes