Subject Re: Form to Form
From Ken Mayer <dbase@nospam.goldenstag.net>
Date Fri, 12 May 2023 12:45:34 -0700
Newsgroups dbase.getting-started

On 5/12/2023 12:27 PM, Peter wrote:
> Peter wrote:
> I am away without my computer ( a treat to myself).so I can抰 test anything.
> Some clarification for some your questions:
> The pat_no field is 5 numbers. That is the field that is ultimately responsible as unique to select any choice, not last _name+first_name, although there is an index of patienttest.dbf that is upper(last_name+first_name) with spaces and trims as has been described many times, appropriately, in your books.
> Even if user enters last_name into entryfield1 to determine order of grid, I have always wanted to use pat_no as unique field to define how later seeks are used. User has choice of entry as either last_name or pat_no, onLostFocus of entryfield1, index is selected for order in grid. After pushbutton_goto is clicked, I planned to use pat_no as the way to proceed to second form in order to edit.
> Maybe a bit wordy, but there you have it.
> I抦 a bit surprised that there isn抰 a best way to get pat_no from firm1 to form2. These 2 forms use the same dbf.

Actually they're my books, not Mervyn's ... although if he were so
inclined he could probably write something at least as good as my books. :)

Anyway, in The dBASE Book, Volume 1 (3rd edition), Chapter 13, there's a
section on "Communicating Between Forms". I seriously suggest you look
at that. It covers this in some detail. My earliest suggestion of using
custom properties of forms works well for me (and I often use it with
reports as well), and is covered in here.

Ken

--
*Ken Mayer*
Ken's dBASE Page: http://www.goldenstag.net/dbase
The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp
dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm
dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm
dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm
dBASE DOS to Windows Tutorial:
http://www.goldenstag.net/dbase/DtoWTutorial/00_Menu.htm