Storing file location/data in a local DB

Question

I'm developing a Lead/Opportunity tracking system. Currently I store information in a .MDF (LocalDB).

 

As of now I have things working, storing my project bid dates, statuses etc.

 

For some of these projects, there will be files associated with them, that I would like to store, and access, such as specifications or plan files. I am lost at this point, and I have come to you!

 

What would be an efficient way of storing file information in my database, and accessing it when I am querying for normal data?

 

I am thinking of creating a seperate table called "Files", with the columns "ID", "FileName", "FileLocation", "FileType".

 

I am not sure how to make this work, what would you do?