Why is front-end CRUD so difficult in Joomla?

[dwoosley]

I have invested many hours researching, testing, and purchasing (my mistake) extensions that I hoped would allow a front-end user to list, insert, update, and delete records in a simple table that is defined in the Joomla database. There are many* solutions that list and insert records, but none that perform the basic CRUD operations. That amazes me.

The situation:

--- I am not a PHP programmer.
--- I understand SQL.
--- I need this functionality for several tables.
--- It must be a front-end interface.
--- I will gladly purchase the extension.

For example, assume I have a database table named "interest_rate" with these fields:

--- id (auto-increment integer)
--- description (text)
--- current_rate (text)

I need a front-end interface that has a "Create Interest Rate" button (or link) and the list of existing records. Plus, a way to edit and delete a record. Basic stuff. Is this outrageously difficult in Joomla 2.5? If not, why can't I find extensions that accomplish it.

What am I missing?

Regards,

David Woosley

* I have evaluated and/or purchased lots of extensions, including: ARI Smart Content, RS Forms Pro, ContentBuilder, Phil Taylor's bfForm, BreezingForms, and others. Also, I have read dozens of blog entries that provide PHP code and other (workaround) solutions. Unless I'm being stupid, none of these things provide the required functionality.

[pe7er]

Maybe you could use Fabrik
http://extensions.joomla.org/extensions ... forms/1659

[dwoosley]

Peter, I'm trying it now. I'll post what happens. Thanks.

[dwoosley]

Peter,

You are my hero. I will dance at your wedding and weep at your funeral, or maybe vice versa. I saw the Fabrik extension last week, but somehow missed its full functionality. It works like a charm. Thank you. I owe you one.

David

[seleblan]

@pe7er

THANKS!!!!!!

I may just have found my holy grail.... sort of

You are probably using fabrik yourself... could you confirm?

Regards

Sebastien