Linking a newly created table to the main table?

[Spawny]

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

[bashfirst]

If you are linking the tables as in setting up a foreign key, then you need to use the CONSTRAINT keyword in the CREATE TABLE method.

Bash

[Spawny]

I have the following code in the create table part :
pDatabase.Execute "CREATE TABLE " & TblName & "([TransID] counter,[Date] date,[field] ,[field] text);"

what do you mean by constraint?