Re: creating text items as runtime in forms 6.0

[Quoted] On 29 Nov 2002 23:13:45 -0800, jimyjoshi_at_yahoo.com (DJae) wrote:

>it is good that u r helping me out..but i thnk u dont get my
>point..heres what i am doin and what i want.. i am trying to make
>data entry form for an accounting package which i am developing...this
>form is to be used for posting journal entries...the sample format of
>the enteries is like this...
>
> TYPE | Account Head | AMT
>--------------------------------
> TO | Cash A/c | 2000
> BY | John's A/c | 1000
> BY | Ken's A/c | 1000
>
> now the number of TO's and BY's may vary depending upon the
>type of entry..and the entries of type TO go in the credit table and
>BY go in the debit table..so if u can help me out to create such a
>form ...

non table based multi record block
and you'll have to write your own 'on-insert' trigger to insert in the right table
You don't have to care about the possible number of entries

-- 
Luc Bosman
DEV/2000 Software Engineer
Database & Network Administrator
l.bosman_at_iile.be
 ---------------------------------------------------- 
|  -°)                                          (°-  |
|  /\\  Linux the choice of the GNU generation  //\  |
| _\_v                                          v_/_ |
 ----------------------------------------------------