your other tables should have a foreign key column that will relate to the user table.
when the user logs in using security assist, the users ID will be stored in a session variable
See the profile page, if you examine the recordset, you will see that is filtered on the users ID session variable.
in your forms that insert data that will be related to the user, set the foreign key column of the other tables to use this user id session variable.