Create The More Information Page
Click on the more page tab so we can now work on that page.
This page will display more information from a chosen item on the results page. The hidden field from the results page transfers the record ID to this page, so all we have to do is tell this page to load details from the full_desc and image_big fields that are contained in the record with the ID that matches that POSTed from the results page. Also as information from only one record will be displayed there is no need to use the repeater as we did for the results page.
| Step 1. First we need to do a load record action so the page knows what records it needs to be pulling from the database. So from the Action Builder Click on the + and then select Load Records | Step 2 Select the table that contains the information, for our demo select "Property_search" and then select the 3 fields we will need to use on this page ID, full_desc and image_big, move these 3 files in to the selected box. then click on Next>> to move along to the next screen |
 |
 |
| Step 3. Now we tell the wizard how to find and match the records, So table Property_search ID is equal to POST Hidden1 -The hidden field on the results page contains the ID number of the record, so when you click more it transfers that field information to this page. So all we need to do is pull information from the database that matches that ID number. Add this to the Where box like below. Then Finish. | Step 4.
Click on the page where you want to display your matching record and
then from the toolbox click on  . When the insert table box appears
make it 1 rows and 2 columns. Now click inside one of the table box's and then right click your
mouse and select Insert > Header from the pop up menu. This will add
a new row to your table so you now have 2 rows. Type in your headings in
the top row box's |
 |
|
|
Your table should now look like below. |
|
|
|
|
| Step 5. Now we insert under the headings what information to be displayed from the database. So click in the box under Property Details and then right click and from the pop up menu select "Set Dynamic Value" then from the drop downs select "Load From Data Source" and then "full_desc" like below. Then click OK |
Step 6. Now we make the Picture
dynamic so it will show the correct image relating to the property. To
do this click inside the box under Picture, then from the Toolbox
select " " and choose a default image that will be
shown if no image is available, Now click on the image you have inserted
so it is selected and then right click your
mouse and select "Set Dynamic Value" then "Load From
Data.." and "image_big" like below. |
 |
 |
|
Your table should now look something like below |
|
|
|
|
|
You can add your design
to your page and any fixed information or menus. Then when you've
finished save the page and export your project.
|
|
