I currently have a number of tables in my database, which include these 2 tables:
tblOne - Uid(pk), FirstName, LastName, Email
tblTwo - HCCID(pk), Uid, Category, Description, Company, Manager
In my application I have users from tblOne logging in and creating records which are inserted into tblTwo. Thankfully this is working ok, however, my problem is with the Uid in tblTwo (fk).
When a new record is created in tblTwo, the HCCID(pk) iterates, so i have a numeric identifier for each record. However is there any way i can also keep a record of the user by recording the Uid in tblTwo based on which user creates the record?
Seeing as though this is already a pk in tblOne and I also already have a pk in tblTwo, is this possible?
Any ideas will be greatly appreciated!
View Complete Post