ERD Relationships & Reporting

[yrstruly]

Please look at my data model. I brought in an addtional table to hold export documents, Tables are:

tblDocumentStorage	Add structured fields (DocumentCategory, BatchReference, UploadedBy, UploadTimestamp).
tblPermitInformation	Add BatchReference and ExportLinked for tracking.
tblExportInformation	Add BatchReference, MaterialType, and Quantity.
�� tblImportExportTraceability	New table to link imports and exports.

I need to link Imports and Exports tables to keep track of business procceses/operations to faciliate better management.
Are my tables and linking suffice? See: https://drive.google.com/file/d/1hK9...ew?usp=sharing
Files are to big to upload.

[mike60smart]

Hi
Your BE does not yet have any relationships set.

When I tried to create a relationship between tblPermitInformation and tblDocumentStorage using PermitID
I get the error shown in the attached screenshot.
This is because the field PermitID FK in tblDocumentStorage is a Text DataType. This field must be set as a Number Long Integer.

Also you say that you have created tblExportInformation and tblImportExportTraceability ? These tables are not in the BE.

No-one is going to create these for you.