M/H/R Web - Datapower Page

Moorhouse Web

This database shows how to use a simple search page to find a record rather than using F4

It has two tables:-

Table1

This would be the table holding the records you want to search / select from.

It has one specialied field, 'initial' that returns the capitalised initial letter of the field 'name'.

Temp

This table has two fields, 'name', 'alpha'.

Name: this is used as a link to the field 'name' in table1 by the layout 'results of search'
Alpha: This is used by the alphabet selector to only show records that begin with the letter in this field. This is done in layout 'Show Alphabet' by a link to the Field 'initial' in table1.

It has 6 layouts

Master List of names	This is the list of records to be searched etc.
Search Page	Field to enter search name + button to activate search
results of search page	Shows the records selected by the search
Select for search	Shows one field (name) from table1, double clicking on the name will show all the records that have that name.
Alphabet	The layout has two ways of selecting the initial letter of the name being searched for:- 26 buttons, one for each letter that when you click on it opens up the layout 'show Alphabet' (note - only 'A' has a trap for no records, as i didn't have time to copy it to the other buttons' - should hve set it up as a global script but didn't know how. A selection field, with all the letter in a pick list, and a 'go' button. the advantage is only one script, the disadvantage is that three mouse clicks are needed rather than 1
Show Alphabet	The layout shows all the recods that start with the the letter selected in layout Alphabet. Double clicking on a name will show all the records that have that name.

Return to Datapower Page	Download search example(56Kb)