Combining Master-Detail and Update Function

[AnilNe]

Dear Friends,
Can we combine Master-Detail and Update Function so that record to be updated can be selected from Master-Detail and then can be updated.

Thanks in advance.
Anil

 

[Cheech]

Yes you can. What is the problem you are struggling with. The basic principle is you would list all of your records on the master page and each would have a link to the update page, passing the unique id. then your update page would have a form on it populated from the record sent by the master page link. allow the user to update the info then submit the form with an update behaviour attached.

Cheech

[Peace][Pipe]

 

[AnilNe]

Thanks Cheech for your reply.
Well I have done what u have said. But when i create master-detail page, the detail page contains information of ID passed by master page. I don't know how to make this data appear in update form. Can it be done automatically using wizard or we have to work with codes a bit to make it work?

Waiting for your reply.

Anil

 

[Cheech]

The same way you populate your detail page with a recordset based on the passed ID. Instead of putting the content onto the page just bind it to the form elements.

Select a textbox (or whatever form element you are using) and in the properties you will see a "Dynamic" button, just click this and you will be able to select the recordset and bit you want.

Cheech

[Peace][Pipe]