SA registration linking to other forms

Hi guys
I have security Assist set up and working for registration to my site. I have a table in the mySQL database for members with their registrations details, and need to reuse this information on licence, entry and logbook forms which also have tables under the same database as the registration table is in.
There are tables in the database also for PowerCMS and PowerGalleries which are working OK, just cant get the registration details to link up to the other forms. Any ideas.
cheers and thanks in advance
scott

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.

Hi Jason
Many tanks for your quick reply, has solved a couple of the problems will test the rest tonight.
Cheers
Scott

you're welcome.