I have three sets of tables.
a) for registering new users on "temporary tables"
b) for updating values (actually Inserts/to maintain edit histories)
c) and permanent tables
The a) temporary tables are linked by a primary id. (a main temporary table that contains the username/passwords.)
Rather than try to link the update tables and permanent tables with new sets of primary ids -- wouldn't it be best to always just link the tables by the same single ID throughout on all tables from the temporary table? (Which would mean I could trace back if needed)
