[Solved] How to autofill a field with numerical values

[tivadarpreiss]

Hi
I want to make a DB with house number( basically numbers, but should allow to enter letters too, for ie. 3 and 3/F or 3F), a checkbox, and a text field.

Is it possible to enter house number from 1 to 2000 with autofill/autocomplete/etc option? HOw

Thx

[F3K Total]

If i got you right,
execute ONCE via Tools/SQL... the following command:

Code: Select all

DELETE FROM "Table1";
INSERT INTO "Table1" ("HOUSE NUMBER",CHECKBOX) (SELECT N1||N2||N3||N4 AS I, false FROM
(SELECT ORDINAL_POSITION - 1 N1 From INFORMATION_SCHEMA.SYSTEM_COLUMNS WHERE TABLE_NAME = 'SYSTEM_TABLES' AND ORDINAL_POSITION<= 10),
(SELECT ORDINAL_POSITION - 1 N2 From INFORMATION_SCHEMA.SYSTEM_COLUMNS WHERE TABLE_NAME = 'SYSTEM_TABLES' AND ORDINAL_POSITION<= 10),
(SELECT ORDINAL_POSITION - 1 N3 From INFORMATION_SCHEMA.SYSTEM_COLUMNS WHERE TABLE_NAME = 'SYSTEM_TABLES' AND ORDINAL_POSITION<= 10),
(SELECT ORDINAL_POSITION - 1 N4 From INFORMATION_SCHEMA.SYSTEM_COLUMNS WHERE TABLE_NAME = 'SYSTEM_TABLES' AND ORDINAL_POSITION<= 10) WHERE I between '0001' and '2000');
CHECKPOINT DEFRAG

Then ONCE Menue View/Refresh Tables and see afterwards, what you find in the table ...

[tivadarpreiss]

Thanks. You are an Ace!!!

[D Soyars]

Similar but not the same.
I am trying to connect date and address numbers to create a ID# say opened new file january 15th 2020 and the address is 1234 main im looking for an ID # of 2001151234. Soo... YYMMDDAAAA please help iv been working on this database for far too long