Answer the question
In order to leave comments, you need to log in
Storing links to files in MS ACCESS or Excel tables for 1 record?
Hello. Performing an essentially simple task - to create a simple database for storing brief information about document scans (name, date, etc.) for a simple and quick search, as well as links to scan(s), the number of records will be approximately several tens of thousands. I can’t figure out how to specify several links to files for 1 record (line).
More specifically, using a simple example - there is a record with the fields Id, full name, date, path, if this record belongs to 1 file, then everything is simple, but if there are several files, then how can we specify several paths in 1 cell, or create several fields for entering the path , or duplicate the line with different paths to the files. Another option was the idea of scattering scans into subdirectories and indicating the path to the subdirectory, but again, how to name these subdirectories (by name is not an option, because they can be repeated and scans related to different records will be stored in 1 subdirectory), the only thing that comes in the head to name them according to the data from the 2 * key (most important) fields, and it is also possible that the scans themselves should be somehow identified in a special way.
I would like to know which of the above, or an alternative option, would be more correct to use, so that in the future the database could be redone with the least effort, if necessary, and understand it without much difficulty. Unfortunately, my knowledge in this area leaves much to be desired, and I could not find a clear answer on the Internet. If something is not clear - write.
Answer the question
In order to leave comments, you need to log in
In the first table, specify all users and ID (identification unique number)
ID, First Name, Last Name, Date, all other user data
in another table, list all files, and indicate the owner ID
Owner_ID, document_type, file path/name
Owner_ID and ID will help you find document of the desired owner, or find all documents by owner.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question