Hi, I'm new to access. I would like to be able to create a new record in one table by entering data in another. For instance enter name in employee list and it creates a record under that employees name in the employee record list. It seems simple enough but I can't seem to figure it out. Thanks
could you be a bit more specific with what you are trying to do? It's a bit bizarre that you would want to duplicate data across tables... Are you trying to populate a master/child relationship or something?