Hello @Arnoldg,
First, choose your database:
- is it for a desktop-only program (locking the full tables like with Paradox or dBase)?
- is it with several clients and a centralized server (and possibility to lock only some records of each table like with mariaDB or fireBird), ...?
Then study the choosen SQL engine (primary versus foreign keys, how to make relationships between tables), then choose a SQL manager in order to make the SQL statements \ DDL queries, and to create your database. Only then, you will code with Lazarus (and its components like TDatamodule, TConnexion, TDataset, TQuery, ..., TDataSource, TDBedit, TDBGrid, ..., TForm).
Here are some SQL managers:
- DB browser for SQLite (SQLite)
- FlameRobin or RedExpert (Firebird)
- MyDbfStudio (dBase)
- PhpMyAdmin (mySQL\mariaBD)
- the project .../lazarus/tools/lazdatadesktop (a little bit of everything, like the "Database Desktop" of Delphi)