I don't find a way to define the primary keys for my SQL tables in order to make them linked between them. How do I achieve that ?
Can you drive me to the documentation on this particular point ?
Seems a real good documentation in missing in your tool.
Thanks..
You tool looks very promising.

The primary key is always 'id' for every table. You cannot redefine it for the moment.

When you want to create links, you need to instance a 'Foreign Key' data field
and then, drop a 'Table' in the drop zone of this FK field.

have a look on the videos if you don't understand.

Does it matter to have more than one Foreign Keys linked to multiple tables ?
The videos are not so explicit on this particular point...
Is there any good pdf doc available describing this in detail ?
- Any good tool is always based on a strong documentation
Can you also explain what is FK integrity in properties dialog ?
Thanks a lot.

If you want to create a many to many relation, you can. But it is not handled in forms or layouts if you want to see theses cross reference values.
Ex : multiple select, checkboxes, or list of all related datas. Not available for the moment.

Coding it is not difficult when you understand how the model works.

I will start to write a documentation when the V2.0 will be released. For the moment the source is a bit obsolete.

FK integrity means for example :
if you have items within a category.
When you delete a category, it will delete all contained items.
Or it can leave the items and reset category fk to 0 (null)
Or nothing happens (you must be careful when you delete objects that are referenced by others)