how to fix edit and new button

hi,
how can i make the edit button load the selected record.

i know i should use the db record loader but how?

when i run the debugger in the onload i get

Array
(
    [Approx_Memory_Usage] => 946624
    [Approx_Time] => 0.0153889656067
    [SQL] => Array
        (
            [0] => SELECT `leskaart`.*, `users`.`id` AS `users.id`, `users`.`name` AS `users.name`, `users`.`username` AS `users.username`, `users`.`email` AS `users.email`, `users`.`password` AS `users.password`, `users`.`usertype` AS `users.usertype`, `users`.`block` AS `users.block`, `users`.`sendEmail` AS `users.sendEmail`, `users`.`registerDate` AS `users.registerDate`, `users`.`lastvisitDate` AS `users.lastvisitDate`, `users`.`activation` AS `users.activation`, `users`.`params` AS `users.params` FROM `LES_LESKAART` AS `leskaart` INNER JOIN `jos_users` AS `users` ON users.id=leskaart.LEERLING_ID WHERE `leskaart`.`LESKAART_ID` = '28'
        )

    [data] => Array
        (
            [0] => Array
                (
                    [users] => Array
                        (
                            [id] => 1190
                            [name] => test
                            [username] => test
                            [email] => xxx
                            [password] =>xxxx
                            [usertype] => 
                            [block] => 0
                            [sendEmail] => 0
                            [registerDate] => 2012-05-03 08:30:24
                            [lastvisitDate] => 2012-05-06 18:57:11
                            [activation] => 
                            [params] => {"admin_style":"","admin_language":"","language":"","editor":"","helpsite":"","timezone":"Europe\/Amsterdam"}
                        )

                    [leskaart] => Array
                        (
                            [LESKAART_ID] => 28
                            [INSTRUMENT_NAAM] => Basgitaar
                            [LEERLING_ID] => 117
                            [AANSCHAFDATUM] => 2012-05-29
                            [AANTAL_LESSEN] => 5
                        )

                )

        )

in pseudo i want this

field INSTRUMENT_NAAM  = select INSTRUMENT_NAAM from leskaart where LESKAART_ID = 28
field LEERLING_ID = select LEERLING_ID from leskaart where LESKAART_ID = 28
field AANSCHAFDATUM = select AANSCHAFDATUM from leskaart where LESKAART_ID = 28
field AANTAL_LESSEN = select AANTAL_LESSEN from leskaart where LESKAART_ID = 28

can anyone explain how to make this work?

thanx

Hi redowl,

The record is loaded in the debug just fine, maybe you didn't name your fields correctly ? your fields names in this case should be:

leskaart[LESKAART_ID], leskaart[INSTRUMENT_NAAM], users[id], users[username]...etc

Regards,
Max