Permit ID is Static

[yrstruly]

I want permit ID to be a drop down and the user to be able to slect from that selection or even fill in a Permit ID.

See settings: https://drive.google.com/file/d/1ijr...ew?usp=sharing

SELECT DISTINCT tblPermitInformation.PlantID, Plants.Cultivar AS Variety, Plants.Clone, tblPermitInformation.PermitID, tblPermitInformation.Import_Requestor, tblPermitInformation.Permit_No, tblPermitInformation.Permit_appl_date, tblPermitInformation.Permit_valid_until, tblPermitInformation.Authorization_application_date, tblPermitInformation.Authorization_no, tblPermitInformation.Authorization_valid_until, tblPermitInformation.Date_shipped, tblPermitInformation.Arrival_date, tblPermitInformation.Export_country, tblPermitInformation.Material_type, tblPermitInformation.Quantity_of_material, tblPermitInformation.Import_commentsFROM ((tblPermitInformation INNER JOIN Plants ON tblPermitInformation.PlantID = Plants.PlantID) LEFT JOIN tblExportInformation ON tblPermitInformation.PermitID = tblExportInformation.PermitID) INNER JOIN tblDocumentStorage ON tblPermitInformation.PermitID = tblDocumentStorage.PermitID
ORDER BY Plants.Cultivar, Plants.Clone;

[Welshgasman]

I generally have the ID field as field 1 in the source and the description as field 2?
Makes it easier setting columns visible.

[yrstruly]

PermitID is an auto number. Reading from the PermitInformtion table

[Bob Fitz]

PermitID is an auto number. Reading from the PermitInformtion table

Is that the only column that you want/need?

[yrstruly]

Please see my Data Model. Advice if a seperate import table is needed?
Data Model: https://drive.google.com/file/d/1ijr...ew?usp=sharing
Key Difference Between the Two Forms

1. Database Structure Differences
   
   
   • The Export Form is based on tblExportInformation, which has a Number field (PermitID) that references tblPermitInformation.PermitID.
   • The Import Form works directly on tblPermitInformation, where PermitID is an AutoNumber field.
   
   
2. Behavior of AutoNumber Fields
   
   
   • In tblPermitInformation, PermitID is AutoNumber and is system-generated.
   • AutoNumber fields cannot be manually entered or selected via a combo box.
   • In contrast, tblExportInformation.PermitID is a Number field, which allows users to select an existing PermitID.