Use Chronoforms to manage a Joomla table?

Hello guys,

I am on to a new project - and thought that Chronoforms would be the way to go for a solution.
I want to build a form that is able to manage a joomla table (ie. add/edit/delete table entries). The joomla table itself is a custom one that I build and is very simple.

--
-- Table structure for table `jos_vm_heard_about_us_list`
--

CREATE TABLE IF NOT EXISTS `jos_vm_heard_about_us_list` (
  `list_id` int(11) NOT NULL auto_increment,
  `display_option` varchar(50) default NULL,
  PRIMARY KEY  (`list_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='heard about us list' AUTO_INCREMENT=11 ;

I am not sure how to make the form able to "edit" and "delete" ... Any Ideas??

Thanks

Hi samoht,

You can use ChronoConnectivity to do this in the back end.

If you have SuperAdmin access then I'd install EasySQL which will let you do all these things on any table.

If it's a front-end application then more work is needed!

Bob

Yes, I am needing the more work scenario.
I don't necessarily need it for the front end, but I am creating this for non-techy clients. They will also want the ability to print the results somewhere down the line - so I thought front-end might be nice for that.

I'll try setting up ChronoConnectivity. will this let me "edit" and "delete"??

OK,

I started working with ChronoConnect - and got as far as having the table display plus I added this in the editor so that I could edit the names of each referral:

<?php
$editor    =& JFactory::getEditor();
?>

<table>

    <tr>

        <td>Name:</td><td><input type="text" name="display_option" size="100" value=""></td>

    </tr>

 

</table>

<input type="hidden" name="id" value="">

However, this only allows me to add new entries. What do I need to do to be able to edit entries already made and delete unwanted entries??

Hi samoht,

As this is a ChronoConnectivity one then lets move to a new topic at ChronoConnectivity forums with your question and I will answer there.

Cheers
Max