joaofmateus wrote:I am incredulous!
This is the same Base component since 2011. And between 2005 and 2011 there used to be 2 developers working on Base. They struggled hard to keep this compmonent up and running against regressions and they added small, nevertheless important, improvements to the functionality of 2005. Today we can be happy when someone from the Calc department takes a look at a serious Base problem.
The GUI tools which should allow you to click together some working database always have been insufficient because they have far too many gaps leading new users right into a huge mess of inadequate data types, all fields optional, arbitrary primary keys, no foreign keys and non-normalised tables constantly requiring new category columns. The tools do not even cover all features of HSQL 1.8, for instance it is impossible to apply any default value that is not a constant (DEFAULT CURRENT_DATE) and you can not have admin and user.
RoryOF wrote:Are you prepared to hold the OP's hand and take him through the development of the application he proposes?
Users who barely can handle a spreadsheet with 2 data types don't cope with abstract design concepts and those freedom fighters with some Excel/VBA background immediately start to write macros in order to bypass any conceptual "limitations" (and of course they fail).
As a supporter you find yourself building up the whole database in question or compile a link list pointing to similar solutions. Writing the data definition SQL for a handful of tables, 10 queries, two or three forms can take a full Sunday afternoon. Demonstrating the underlying concepts by examples -- as close as possible to the user's actual problem -- is an efficient way to get "normal users" on track or lose them completely (which is also fine).