Column Naming Question

Hi,

I have a table called Files which holds data about Files held for a project. I also have a table called user. I want the Files table to hold data about who has the file checked out and who initially uploaded the file. Since these two fields will be foriegn keys relating to User.User_ID how can i contain this data in the table - I can't have two columns called User_ID in my Files table...

Thanks for your help Received on Mon May 05 2003 - 17:42:44 CDT