The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
Hi,
not to sure how to put this but here we go.
I have somthing like a file manager.
and i need to have a report of who has downloaded each file.
Now what i need to do is list each file that has been uploaded down the left and then list the date/time in which each user has viewed the file.
so each line woudl look liek this:
<filename> | <user1 date/time> | <user2 date/time> | <user3 date/time> | <user4 date/time> etc etc etc
but i am having trouble getting the data to populate.
i have 3 tables
tblUsers
tblFiles
Clicks
Clicks holds the userID, fileID and DateClicked of who ever has clicked
Not sure if this is clear or if anyone can point me in the right direction.
Any help is much appreciated.
not to sure how to put this but here we go.
I have somthing like a file manager.
and i need to have a report of who has downloaded each file.
Now what i need to do is list each file that has been uploaded down the left and then list the date/time in which each user has viewed the file.
so each line woudl look liek this:
<filename> | <user1 date/time> | <user2 date/time> | <user3 date/time> | <user4 date/time> etc etc etc
but i am having trouble getting the data to populate.
i have 3 tables
tblUsers
tblFiles
Clicks
Clicks holds the userID, fileID and DateClicked of who ever has clicked
Not sure if this is clear or if anyone can point me in the right direction.
Any help is much appreciated.
Posted
You should include at least one field (eg fileid) that is common to your clicks & your tblfiles. With that you can update/retrieve the proper record.