I have an listpage witch gets it content from two joined tables.
The SQL Query looks like this:
SELECT
specialnummer1.TELEFONNUMMER,
specialnummer1.BESKRIVNING,
pbxdata.FLAG1,
TIME(DURATION) AS Samtalstid,
pbxdata.DIRECTION,
pbxdata.CALL_TYPE,
pbxdata.CALLER_PHONE,
pbxdata.TIDPUNKT,
pbxdata.CALL_DATE,
TIME(RING),
specialnummer1.ID
FROM specialnummer1
LEFT OUTER JOIN pbxdata ON specialnummer1.DIREKTNUMMER = pbxdata.DIALED_PHONE
ORDER BY pbxdata.CALL_DATE DESC, pbxdata.TIDPUNKT DESC
The listpage works fine and get all the entries witch i want.
Now on that listpage i would like to add an edit box where i can edit the entry from the table specialnummer1.TELEFONNUMMER where ID=1
And when editing this box it should also be possible to save the entry so that entry i table specialnummer1 with ID 1 is updated and the listpage is updated.
Is this possible?
I hope that you understand what i'm trying to accomplish!
/ Kristian