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?