Now when creating a thingy, for example a vendor database, we create thingy01 with all the fields for the company details. Like company name, address, telephone and fax. Then we created another thingy called thingy02. Thingy02 has field for category with rows like, Audio Equipment, Video Equipment and Lighting Equipment.

Then we link thingy01 with thingy02. This way we can categorize the companies with the equipment that they sell.

Currently this works ok if the company only sells one type of equipment. The moment the company sell two or more types of equipment, it seems that it is not possible.

What am I doing wrong? Have I missed a step?

If anyone knows how to do this, please advise.

P.V.Anthony

--- (Edited on 22-October-2009 12:30 am [GMT+0800] by pvanthony) ---

Currently, the Thingy does not do one to many, or many to many relationships. 

Ok. I am sad. Thingy is a great module.

I think I heard about someone who is working on this, though.

May I contact the person who is working on the one to many code? I am not a programmer but I could help in testing or documentation.

Thingy is great now. With the one to many and many to many function, Thingy would be awesome.

P.V.Anthony

--- (Edited on 19-November-2009 12:23 am [GMT+0800] by pvanthony) ---

I think, as far as I understand the question, Thingy supports 1:n and it's
possible to solve this.

You need a third Thing, e.g. thing01to02 and register here,
what thing02's a thing01 sells.

I did this e.g. with

companies
<--seminars -->
seminarmodules

For reporting, the SQL-Report is perfect.

(However, field names are horrible in Thingy. I changed Thingy, so I can define myself how to name a field.)

Sorry for getting back on this so late.

I am trying to understand the above and unfortunately I do not get it.

Let me make another example,

There is a company table and in the companies table, we have, fields like, company name and company address.

Then we have a magazines table with fields like, fashion, web and music.

We also have a members table. In the members table, we have fields like name, address, [company] and [magazines]. The fields in square brackets are linked to the tables mentioned above.

How to make this work with the example mentioned above? Sorry for troubling you as I do not understand.

P.V.Anthony

--- (Edited on 19-November-2009 12:18 am [GMT+0800] by pvanthony) ---