Hello Mark

Good tip. I would suggest that you also put the tip on : https://wsx5.afsoftware.fr/

If you are not a member and don't want to be, then maybe Axel will put it in the forum, so it will be available, also in the future.

Hi John,

I have signed up for that forum, just recently. Not had time to look round yet.

But if, Axel wants to add this snippet, then please do.

The snippet actually came from jtable.org

DBviewer is based on the open source jtable.org and it would be great if the WX5 team could actually implement the child tables, then simple two table relational databases could be implemented.

Hello Mark

If you work with databases, I could recommend the Appgini.

You can see an example here : http://eksempelsite.dk/side-4.html

It is very easy to make simple parent-child relations, and to create table and detail views.

Users can be attached to groups where it is specified if they have insert, view, delete and edit rights for each table. It can even be set up for a specific user. It is not free, but the price is very fair. It is not an alternative to X5, as X5 is for creating websites, and AppGini is for creating/maintaining database solutions. As you can see in the example it is easy to integrate in X5.

Thanks, but I have already created my own child tables, using jtable for simple relationships, such as, members and subscriptions.

Hello Mark,

I have already included your tip on my forum. But I cannot check it because I have no DBviewer object.

If you could post & share your code to manage child tables it's could be very nice for us, and for all others users.

Regards

https://wsx5.afsoftware.fr

If you go to

http://www.jtable.org/Home/Documents

and select "Getting Started". This will show you the rudiments of creating your own JTable.

There is a demo of child tables at

http://www.jtable.org/Demo/MasterChild