Trying to create a database of magazine subscribers using Thingy. So currently we created two tables. Table one called "company" and the other table is called "readers"

The "company" table has these fields, "coy name", "address" and "country". The "reader" table has these fields, "name" and "company". The "company" field in the "reader" table is linked to the "company" table.

When the data is searched in the "readers" table, the search results shows only the following, "name" and "company". It would be great if the search result would also show the data of the related table called "company". Then the search would show something like this, "name", "coy name", "address" and "country".

Please share on how to make the display possible.

P.V.Anthony

--- (Edited on 28-January-2010 1:08 am [GMT+0800] by pvanthony) ---

The simplest way to do this, is using one or more SQL-reports, although the fieldnames are not really simple to use (if you use standard Thingy)

Look for this to see an example, using three tables:

http://digitale-lebenswelten.de/seminarsuche2

Thank you for the tip. I hope in the future, they would allow for display of related table fields within Thingy.

I really like the way the data was displayed. Especially the hiding of the data and the displaying of the data when clicked on the cross. If it is ok with you, I would really like to know how that was done.

I find Thingy is really a great tool. Really great tool. Especially for people like me who are not programmers.

P.V.Anthony

--- (Edited on 3-February-2010 11:58 am [GMT+0800] by pvanthony) ---

If it is ok with you, I would really like to know how that was done.

Have a look at the source code (toggleDisplay).

This has to be build in in the template. Details I unfortunately can/may not provide.

--- (Edited on 04.02.2010 23:50 [GMT+0100] by martien) ---