Re: SQL Forms 3.0 -multiple records-
Date: Tue, 27 Apr 1999 15:17:29 GMT
Message-ID: <7g4ke3$srd$1_at_nnrp1.dejanews.com>
[Quoted] Would I be able to use a master-detail form for the following example? What I want is to input a phone number is block 1, and after it has been entered return information from table1 and information from table 2 in multiple records in block 2.
> I think you should scrap your current version of the form.
> Create a new one, and follow the menus to create a default
> master-detail form.
>
> You will find that the detail block will
> fill with the matching rows when you
> 1 Display a valid record in the first block
> 2 Move to the 2nd (detail) block and execute a query.
>
> The form will do the work of your cursor for you.
>
> Later, you can spend many happy hours automating it
> with key & event triggers
>
> Good luck!
>
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Apr 27 1999 - 17:17:29 CEST