I have a database that creates 2 things when a new user is entered. The first is it creates most of the data into a main table and secondly it creates a new table. How can i get this new table to link itself to the main table through vb? what is the sql statement to create the linkage between the 2. thanx in advance