Export Uploaded Documents with Meta Data

[yrstruly]

I intend to create a table to hold meta data for documents that has been uploaded. This process is some what tied to this importing of documents see: https://www.accessforums.net/showthr...246#post531246.

What would be the best approach without redundant tables /andor in terms of dimesional table designs.
1.1 Should i just amend already created table for the import proces as can be seen by following above link or do i create an entire new table that hols the meta data.
1.2 Do i create an entire new form for export or can the import form just be amended to serve a dual purpose.

See FE & BE https://drive.google.com/file/d/14S2...ew?usp=sharing

2. Export Process EnhancementsCurrent Issues:
 No centralized system for storing export data.
 No linkage between export documentation and import records.
 Missing tracking of essential export details.Proposed Solutions:
 Create a dedicated export management section in the database.


 Mandatory fields Variety, Clone, Requestor, Permit No, Validity Dateo Date Shipped, Destination Country, Material Type, Quantity
 Implement a document repository similar to import storage.📌 New Feature: Export-Import Linking
 Create an import-export traceability module that automatically links records based on batch numbers or permit references

[yrstruly]

Existing form for import.

[madpiet]

What metadata do you want to export? If it's part of the document already, you should be able to use something like XQuery to extract the bits of information you want. If it's not part of the document already, how is this metadata added?

[yrstruly]

Meta data i mean the data thats going to be in the table. See the requirements for what this table should include.

What metadata do you want to export? If it's part of the document already, you should be able to use something like XQuery to extract the bits of information you want. If it's not part of the document already, how is this metadata added?

[madpiet]

Oh, that's not metadata. Metadata is "information/data about data", not the data itself.