Hi,

I would like to be able to link DNN users with my company's employees. In order to do that, I would need a foreign key field i DNN's database Users table.

 Can I just create one? I I did, would I be able to edit that field through the default "Edit user account" form in DNN?

Otherwise, could I use the field named "AffiliateId" for that purpose, since I guess I don't need it for anything else?

Thanks is advance,

Daniel Carbonell

I would advise against adding any columns to any of the core DotNetNuke tables such as the Users table. As for using the AffiliateId column (which is used by the Vendors/Banners feature), that might be a possibility if you never plan to make use of that feature. I would, however, want to look more closely at the database schema and the Vendors implementation to be certain that populating this column with your own data would not be a problem.

You could store the presence control Id as a custom property in the user's profile but if you intend to perform a join between the DNN users table and your own database table, that would make for a very messy join.

My preferred approach would be to create an additonal table say "UsersPunches" containing only two columns - UserID and PunchID - and use that in a one to one relationship for creating lookups or joins to your own data.

---

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner