using Chrono connectivity to display data from two tables

hi

can i please ask help in using chronoconnectivity to display two tables. one is from a table i created and the other could be from jos_users or jos_compropiler.

i managed to make the form using the wizard and display it using connectivity but i need some other data from other tables to be shown automatically with out user input.

i searched the forums and could not find any answers. If there is something similar i apologize and many thanks for you help.
😀

Hi rrmayari,

As it is ChronoConnectivity can only connect to one table. But there are a few ways to get round this.
[list=a]

There is a hacked version posted in the forums here that can connect to multiple tables.

You can use a MySQL View to join two or more tables and link ChronoConnectivity to that. You do need to manage updating the View carefully.

If the User ID is the jos_compiler table then you can use ChronoConnectivity to connect to that, then use something like $user = JFactory::getUser({cf_user_id}); in the body box to get the user info for each user in turn.

[/list:o]

Bob