auto number
1 Topic
Auto number with prefix
Hello, In my database I have a table (table1) with the primary key (PK) Internal Claim Number (ICN) as an auto number with the format "2023"0000 (2023 as the year). This PK is linked to another table (table2) where all values are displayed to my liking as for example 20230009. Everything worked quite well to the point of creating a query where I wanted to link the foreign key back to the primary key, it did not work. It only works when I manually type in 9 instead of 20230009 for example. Does anybody have an idea how to fix this problem? Best regards MoritzSolved1.7KViews0likes9Comments