Re: SQL Forms 3.0 -multiple records-

From: <analyst_user_at_my-dejanews.com>
Date: Tue, 27 Apr 1999 19:59:02 GMT
Message-ID: <7g54u4$cod$1_at_nnrp1.dejanews.com>


[Quoted] I apologize for not being very clear. Block1 is based upon the PHONE_CALL table. A phone number is entered into a field in Block1 and I want information from that PHONE_CALL table and the CUSTOMER table to populate fields in BLOCK2. The problem I had was that I only could get 1 record in BLOCK2 where I should get multiple records.

If I were to use the Master-Detail relationship. I would set Block1 as the Master and have a Base table of PHONE_CALL. How would I set up BLOCK2?

> From what I _think_ you are saying, that sound perfectly fine!
>
> You can input a load of records in the main block.
>
> For each of those records, you can use the form to
> insert/update/delete and query the records in the second block.
>
> If you want stuff that _belongs_ in block 1 to appear in
> multiple records in block 2 when you run a query,
> use a post-query trigger in block 2 to fill your choice
> of non-database fields in block 2.
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Apr 27 1999 - 21:59:02 CEST

Original text of this message