I have an access table named "Import" where I have a column "Import_ID". It comprises 4 parts which help me identify each import consignment uniquely. For example "2018-19 Akh Cig 1" is a name of a single import and no other import has the same name. Seeing this I know which import is for which year, which station, what product and it's sequence. I insert data directly through table, without using any form. So, these 4 parts goes into a single cell ("Import_ID") as Short text format and with "Indexed: Yes (no duplicates)" constraint. My question is - Is there a way so that when I enter value to this cell I get 4 drop-down for the 4 parts but when entered completely they create a single cell value? They can come from a value list or I could have a table with 4 columns which feeds the 4 parts of "Import_ID" column but then converts them as a single value string. This would help me avoid typo for entering the field.