Yet another question about JOIN tables

randyscott777 07 Jan, 2013
I'm using Joomla 2.4 and ChronoForms 4 and have the following multirecord DB loaders:

First DB multirecord loader (but is the secondary file):
Basic - Table: jos_categories, Model ID: Categories, Fields: title
Advanced - Load Data: no, Enable Assoc: No, Assoc Models: Articles
Data Displayer - Enable data displayer: no

Second DB multirecord loader (which is the primary file):
Basic - Table: jos_content, Model ID: Articles, Fields: empty (blank)
Advanced - Load Data: yes, Enable Assoc: Yes, Join Rule: Categories.id = Articles.catid
Assoc Models: Categories
Data Displayer - Enable data displayer: yes,
Display fields: Categories.title:Category,Articles.title:Article

My problem is that it displays about 50 lines with 2 columns, all entirely blank
GreyHead 08 Jan, 2013
Hi randyscott777,

I think you have the Join rule in the wrong action. Please see this FAQ

Bob
This topic is locked and no more replies can be posted.