I will probably embarrass myself with this most basic question, but I am a newcomer to Access.
The question below illustrates the essence of what I am trying to accomplish:
I have two tables in a database. Table A has 2 variables, ID (primary key, autonumber) and Last Name. Table B has 3 variables: ID, Last Name and Age. What I want to be able to do is use a Form to enter ID and Last Name in Table A, and have those data show up identically in Table B. (I can then use another form to add Age to Table B.)
Any help would be greatly appreciated!
The question below illustrates the essence of what I am trying to accomplish:
I have two tables in a database. Table A has 2 variables, ID (primary key, autonumber) and Last Name. Table B has 3 variables: ID, Last Name and Age. What I want to be able to do is use a Form to enter ID and Last Name in Table A, and have those data show up identically in Table B. (I can then use another form to add Age to Table B.)
Any help would be greatly appreciated!