oining / retrieving information from another table (v5 + v6)

Hi,

Can somebody help me..? I desperately need some help ;-)

I have to read from all the maching 'requests' (easy), all their 'infolines' (several key=values), so i will have a table like;

request_id, user_id, request_date, request_status, info_key1, info_value1, info_key2, info_value2, info_key3, info_value3

Yes, i know that this should be easy, but for some reason, I can not do it, no in ChronoConnectivity v5 or v6.
I also have problems with the v6 and the [add new model] that is not working, so i appreciate the v5 solution more - this time. :-)

TABLE:REQUESTS
request_id
user_id
request_date
request_status

TABLE:INFOLINES
info_id
request_id
info_key
info_value

Hi casals,

v6 is better so we focus on v6, please make sure that you update to the latest Chronoforms before testing.

You have multiple infolines for each request ? if yes then just setup the infoline as a new model and in the relation type select the "multiple matching" and set the foreign key to "request_id"

Best regards,
Max

Hi Max,

Fine, but i have the problem with the v6 (as in the other topic).. :-(

Meanwhile, I would be very happy to hear suggestions / instructions on how to accomplish the above-mentioned problem.. even with version 6 :-)

Hi casals,

Apologies for the late reply!

Please let me know where we are on this issue now ? you still have a problem with v6 ?

Best regards,
Max