I am in the process of analyzing the usefulness of Base. I discovered ACCESS2BASE library. Using this I started developing a database. This database uses a lot of entities. Today I discovered that Base with Firebird and ACCESS2BASE does not allow yoy to have relationships on more than 1 field (bummer! in MS Access that has been made years ago). Being fed up with developing for a while, I closed everything down, shut the computer and had a meal.
On restart the full library of modules was empty. Nothing there any more. 2 Questions:
- Why act as if you can have relations with more than one field but fail to do so?
- How is it possible that a module is emptied without my saying so.
A somewhat hazardous system, Base seems to me…Aantekening 2019-09-02 174003.jpg. This is how relations can look like in MS Access. This does not work in Base wik the Relationtool, although it looks like it was built to accomodate it. And i succeeded in adding a picture.