Hi All
I'm a complete newbie to Joomla and creating components. For the first component I have a table
CREATE TABLE `#_anesfhs_indentures` (
`id` int(11) UNSIGNED NOT NULL,
`i_date` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`i_sdate` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`i_apprentice` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`i_parent` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`i_master` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`i_gros` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`ordering` int(11) NOT NULL,
`state` tinyint(1) NOT NULL,
`checked_out` int(11) NOT NULL,
`checked_out_time` datetime NOT NULL,
`created_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `qrk6m_anesfhs_indentures`
--
INSERT INTO `qrk6m_anesfhs_indentures` (`id`, `i_date`, `i_sdate`, `i_apprentice`, `i_parent`, `i_master`, `i_gros`, `ordering`, `state`, `checked_out`, `checked_out_time`, `created_by`) VALUES
(50, '2029-04-10 00:00:00', '', 'Robert Falconer', 'on of William Falconer, merchant burgess of Elgin', 'Andrew Aberdeen, merchant burgess of Aberdeen - merchandising', 'RD11/308', 1, 1, 0, '0000-00-00 00:00:00', 309),
(51, '2026-04-21 00:00:00', '1659', 'Magnus Taylor', 'son of John Taylor', 'Alexr Webster, tailor, lawful son to John Webster in Pittendrum', 'SC1/60/24', 2, 1, 0, '0000-00-00 00:00:00', 309),
(52, '28 February 1671', 'NLS/Ms 21178', '1659', 'Mr Alexander Crawford', 'son of James Crawfurd at Mill of Strichen', 'Mr James Crawford, Writer to the Signet', 10, 1, 0, '0000-00-00 00:00:00', 309);
The six i_* are used by me the rest by joomla. The table has 2,000 odd records. All I want the component to do is :-
ADMIN
Add,change, delete Records which will require list with search and form.
USER
List with search leading to form with printout.
The List view will also have an explanation at top about data set and the data from field i_gros (possible popup from i_gros to expanded explanation.)
My problem is that I'm on a steep learning curve 'cos I'm terminal Cancer and I can't figure out how to go about Cook's Pro
Maybe if I can get thru this one I can get on with the others waiting in the queue.
Cheers
Niall
