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.

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.