This is the second part of tutorial on creating Master and Detail pages, using Dreamweaver. In the second part of the tutorial, we will create the detail page, which is a page shows details of a given record.

1. Double-click detail.asp page, to open it

2. Select Bindings tab (under Applications panel)

3. Click + sign, and select Recordset (Query)

4. Enter recordset name of rsShowUser

5. Select Connection, eg. connTest

6. Select table, eg. test.user

7. click All option, to select all fields

8. select Filter of userid, select sign of =, select URL Parameter and enter userid, to filter by userid using url parameter called userid which was passed to detail.asp (see post on creating master page to see how to pass url parameter to detail.asp page)

9. click OK

10. Select Insert > Form > Form, to insert form

11. Change form name to fmUserEdit

12. Click inside the form element

13. Select Insert > Table, with 6 rows and 2 columns (the last row is to contain the submit button)

14. Enter names or labels for the fields in the first column, eg. username, password, first name, last name, occupation

15. Click cell in last row, second column, and select Insert > Form > Button

16. Click in first row, second column, and select Insert > Form > Text Field

17. select No label tag option, and click OK

18. Copy and paste this text field into the other cells in the second column, except the last row, which already has the submit button

19. Change the name of the text field to match that of the database table field, whose value they will later contain, eg. username, passwd, firstname, lastname, occupation, respectively

20. Select each of the text field, and click the Bind to Dynamic Source button for the Init Val

21. Double-click appropriate dynamic field to use for the current selected text field (repeat steps#20-21 for each of the text field, selecting the appropriate dynamic field for each text field)

22. Click within form element

23. Move cursor to just after opening form tag, before the starting table tag

24. Select Insert > Form > Hidden Field

25. Enter name for hidden field, eg. userid

26. Select Hidden Field element

27. click the Bind to Dynamic Source button for the Value

28. Double-click the userid field, to bind value of userid field to this hidden field

29. Select Server Behaviors tab (under Applications panel)

30. Click + sign, and select Update Record

31. Select table to update, eg. test.user

32. select record from: rsShowUser

33. select unique key of userid

34. click Browse button, for updating, go to field, and select master.asp

35. select form of fmUserEdit

36. click OK