Re: Newbie Forms ? - Browsing Records

In article <5b0td4$9oa_at_lily.redrose.net>, <jhostetter_at_dande.com> wrote:

> I am creating a simple form (v4.5) to update a table. This form can
> only show one record at a time, because the number and size of the
> fields fill up the screen. It would be nice if the users could
> select the record they want to modify from a list of records (such
> as a browse button). I would like to let the users hit a button
> which lets them browse through the records (in a separate window).
> They can then double-click on one of these records, and it will
> bring it back to the form for updating.

You can try to put all your items in one block, but on two canvases. On the look-up canvas, set your records-per-block to 20, so the user can see 20 key items at once. On the other "data" canvas, set all those items at 1 record-per-block.

With this setup, the user can scroll up or down to the desired record, then tab into the data items (on the other canvas). Actually, you don't even need a separate canvas to do this--you could just scroll the canvas right or left to see the multiple records or all the data for one record.

Good luck, and I hope this helps.
Steve Cosner Received on Mon Jan 13 1997 - 00:00:00 CET