weird value list question

[pmmarketing]

I am developing a FM solution for a church and the staff wants to be able to view a list of all our members (2,000+) and insert them into an attedance database. I basically have a portal to our members file and when the user clicks on their name it inserts them into the attendance file. Everything works fine.

They have asked me if it is possible to have a list pop up that they could simply highlight a name by typing part of it and press the enter key to select them. They would also like to be able to continue in the list until they press an ok button with the mouse. The selected members would then be inserted into my attendance database.

The reasoning behind this is our users have to enter so many records and this seems to be the fastest way to do it. Any suggestions?

[Mike D.]

I have done something similar to this. I suggest you create a layout in the members file that displays the members in list view. Then have a checkbox field associated with each member. In the footer of the layout I put a "Submit" button that runs a script that loops through the records looking for a value of 1 in the checkbox. If it finds one, it creates a record in the attendance file. Your script should look something like this:

Freeze Window

Allow User Abort [On]

GoTo Record/Request/Page [First]

Loop

If [Checkbox = 1]

Perform Script [subscripts, CreateAttendanceRecord]

End If

GoTo Record/Request/Page[Exit after last, Next]

End Loop

Replace [No Dialog, Checkbox,""]

The reason for the replace step is to clear the checkbox before creating the next attendance list.

HTH, Mike

[stardust]

Since you're dealing with such a large group of records, you may want to consider sorting your members alphabetically. I would suggest creating a form that would generate a list of members whose surname begins with "A" etc., and checkbox by each name.

Let's say you pull up a list of members whose last name start with "B". You could then check off each member in attendance.

Hope this helps.