Populate Multiple Rows in Form Builder

From: Evelyn <onezero_at_post1.com>
Date: Wed, 19 May 1999 20:19:09 +1000
Message-ID: <37428ffc_at_news.ausmail.com>



[Quoted] Hi all,

Thanks for taking your time to read my posting and hopefully u can help me to solve the problem.

I have a Form that uses multiple rows (see attachment), I have another LOV button called Invoice. What i would like to do is when i click on the Invoice_LOV_button, it will automatically populate the rows in the Form.

i have try to put my SELECT statements into the WHEN-BUTTON-PRESS trigger of [Quoted] Invoice_LOV_button, however it's not working due to this multiple rows. i could done this for some other single line fields but having a big problem with multiple rows.

I will be really appreaciate if u could help me solving this problem, i need the solution asap.
[Quoted] Thanks in advance!

Regards
Evelyn

begin 666 invoice.gif

M1TE&.#=A;_at_*]`/<`````````0 ``@ ``_P`@```_at_0 `@@ `@_P! ``! 0 ! 
M_at_ ! _P!@``!_at_0 !@@ !@_P" ``" 0 " @ " _P"@``"@0 "@@ "@_P# ``# 
M0 # _at_ # _P#_``#_0 #_@ #__R ``" `0" `@" `_R @`" @0" @@" @_R! 
M`"! 0"! _at_"! _R!@`"!_at_0"!@@"!@_R" `"" 0"" @"" _R"@`""@0""@@""@
M_R# `"# 0"# _at_"# _R#_`"#_0"#_@"#__T ``$ `0$ `@$ `_T @`$ @0$ @
M_at_$ @_T! `$! 0$! @$! _T!@`$!_at_0$!@@$!@_T" `$" 0$" @$" _T"@`$"@
M0$"_at_@$"@_T# `$# 0$# @$# _T#_`$#_0$#_@$#__V ``& `0& `@& `_V @
M`& _at_0& @@& @_V! `&! 0&! @&! _V!@`&!_at_0&!@@&!@_V" `&" 0&" @&" 
M_V"_at_`&"@0&"@@&"@_V# `&# 0&# @&# _V#_`&#_0&#_@&#__X ``( `0( `
M_at_( `_X @`( @0( @@( @_X! `(! 0(! @(! _X!@`(!_at_0(!@@(!@_X" `(" 
M0(" _at_(" _X"@`("@0("@@("@_X# `(# 0(# @(# _X#_`(#_0(#_@(#__Z `
M`* `0* `_at_* `_Z @`* @0* @@* @_Z! `*! 0*! @*! _Z!@`*!_at_0*!@@*!@
M_Z" `*" 0*" _at_*" _Z"@`*"@0*"@@*"@_Z# `*# 0*# @*# _Z#_`*#_0*#_
M_at_*#__\ ``, `0, `@, `_\ @`, @0, @@, @_\! `,! 0,! @,! _\!@`,!@
M0,!_at_@,!@_\" `," 0," @," _\"@`,"@0,"@@,"@_\# `,# 0,# @,# _\#_
M`,#_0,#__at_,#___\``/\`0/\`@/\`__\@`/\@0/\@@/\@__] `/] 0/] @/] 
M__]_at_`/]@0/]@@/]@__^ `/^ 0/^ @/^ __^@`/^_at_0/^@@/^@___ `/_ 0/_ M_at_/_ ____`/__0/__@/___R'Y! ``````+ ````!N`KT```C_`+<)'$BPH,&# M"!,J7,BPH<.'$"-*G$BQHL6+&#-JW,BQH\>/($.*'$FRI,F3*%.J7,FRI<N7 M,&/*G$FSILV;.'/JW,FSI\^?0(,*'4JTJ-&C2),J7<JTJ=.G4*-*G4JUJM6K M6+-JW<JUJ]>O8,.*'4NVK-FS:-.J7<NVK=NW5P'(G4L1`,>Y="?:=8J7*5ZY M.O\.W$N0,$G#`A$7'OJWKUZX(Q$K;C_at_Y8>7!!2\KU&R0LTS#A#WOE(R3]#;1 M(15[1FU3M&;6D!]GE_at_B;LVK:$&&SO'WZ*.^:IG5W_&V9J.O-L5-W[KW7<6+ MS3$_APZX^&R[S?-.[\V]>U_MI9<[^D_\\S;VZ=$71T:(/31Y\'>7,W</WZ?J MO/BU"T_N,'AZ\M[]]Q]S"_D'(("A"7_at_@@:/)=YYZ/1G8'8/215;=8.EE5V%\ MLYV6X8) F8;_at_@@/RMU%C%8)&XH$E3G_at_0BBRJIZ)W(+IX$V\*EB=8C-*YA]*% M/_at_ZX'T,X]EBC?1V.B%Z+)F)4F8]*1MFB;>QM*"2/Q(7788Y(OHBA8U#^B.6* M'A6IY) PB<C=E38V>=&35I(9I'S6T3GCG48FF9.*"J*Y6Y5'4KB>C'G..)R# MA1JGYX=YNJD1G')BB."55'H9Z7.3KNCG28;2%Q2D$WI:4G"%ALDACVL&RI.: MC$;_Z:B3_at_*)7&'22)@@D<I;*^F6 `=ZZ*EU0;KH2J!Y>J.I'.]*8:GUW_at_3?G ML7MVYJRL#[YJK5_79B1LMMQVB]2VV8+K[;CDCB;NM>>6JRZ1=*8$XZFX`L=L MN^;J1Z]+X^&;+(2,[;OANLWJ*2:_AT7[;ZX-$JHEJBJIF93#`"MGJ+OW*G=C MQ00;W"APB/XIL&\81QQ?I_,>FN1XSN+'8'O95>M<>YPBVG*OHKX$IZ\L-RP> M?.G&BMEYM_at_:]\,\4OERRR!VG>G"922OM]'R9GBDGD\@Z*"";QMJ<=749FEKP MEB[VC/":K0HJ-JPREEUMFTC;Z>K9&6-][[-2A\JP2&;:UJTWW!;YJO3$HW;L M-4COTAUG:\D:3F;;\:Z<,=-;)NYWBI?*#>V)2=^Y(]]OCJEWS& K^[7;-KY+ M$ZA3^LMXNP\"7G7HUOUFN>5L0Z[PWF/C"[O:%!--(^>/*YOEQ;E.N?I#DK&) M]\FW4]KCL[0#?[CH7-^>YNY1UVXQJFL/2CJ?P=L<J_-+'U^CT(?YB[*Q8!HY M+?JBCSKMKO!+C_S+B1Z--["4_at_TYZL?#C6/&^%$#S@<5^WD)@WPS(0+8HD%L/ ME$T#)WB6"*(K,!:DH 8WR,$.>O"#( S_H0A'2,(2FO"$*$RA"E?(PA:Z\(4P MC*$,9TC#&MKPACC,H0YWR,,>^O"'0 RB$(=(Q"*:[Q](3*(2E\C$?TCBB5", MHA2G2,4J1M&)5LRB%K?(Q2YZD8I8_*(8QTA&,);QC&C\8AC3V,4ULO&-<'0C M'.=(1RG^(S=,::(>F0C%QOCQCX#TXS:<&,A"&O*0B$QD(_at_<I"44Z\I&0%"0A M(TG)2AZ2D99<Y"0SR<E.8K*3H RE) >Y1R4V,H]WE$_at_?2\G*5B81DZZ,I2QG M2<M8PK*6N,QE+6^IRU[Z4H^\_&4I_at_RG,8NJ2F,9,9C('R4R&G'(I2)16U_at_BR M2F4R$9G6S&8O[[&IS6XJD9O>]"8XETG(<)ISB>,\ISI?><=4+N292HDF``' M#W[XJYKB+.<Z][G'=/+SE_[\YS;U&<Z "C27!CVH-9GI3H7 ,RG1#(T]Z1D: M=^*SFPE5J#(SJE%;$K2CQ>0H0C\*4H"2M*3Y;.8[,PB2B&ZCD?6,J3TE<1J+ M/A$`YA0I2H]YTIWB4J<^16=/%SK4H,H2J$;UJ$H%0E.#/!0I+FVD'VF*TX%< M5)M(3:HKLVI4K_at_;5JULMJE99"=:Q7K.=U'RB4UGZ$9?6=(G-L6DC<RI6L_)T MKG:=95E1NM=AUC6O0L4K8(7)4*M&L2!/_SV*6W$Z_at_,8.X!]Q-:Q@,?K7P1ZU MLI;M*T_at_U"TS,#I:S9BWL2Z=(3;9Z9+%,C"Q3;TK7R5IVH*Y];1-!JU#:!A:G MLO5K;'.K5[0*9+9,-6U'4.M8)*IVM+O=J&=Y.]OEYM6V`H4N.Y/+7.E^U;<K M1>6:4IL8N>(VG]1E;BNMNT_RKI.\YE5G>DLJVNQ"\XYQ+2YDNRO9[U(VO.+5 MK7WS&TWGVA6]__at_UM@,7;7H<*ER.HA2M]5XM?P_at_Z8P ].ZGI;NU^L1KBK%Y8M M,[UXX(TL5I UK2^%^;O+#/MTP_at_4U\7A5S%<6`W:0CM3N:KP[8A+WML&O13%X M*YQ-'=^7QS;N;/]3&S)DB*;2D V]:H]=_&(F=]3'%L:Q2:7\62<+N,COU.YO MAYE6*M\5R$%NKI>?:^7:EOFV86[GF/G+R(=_at_6;$-=3-K4[QF-I\YNG?^)X#K M/%8HX_G-"0%T4>09$243E<\01K2$\\S//8.9MW[6LQ/=G,<TFF326L%TI9VB M:9)T.IZ"ELJG'<J4-*;YU*A.M:I7'<Y0.W4L=<RB'&--ZS?.NM:X-F.N=VW% M6]?:U[S.-;"#3>PICCK0L!;E'S^I[&:#DMG.CC8_at_H2WM:O=ED]6FMK6MK>UM M>WO9QT:(J[.B:(^6.[>15NZY3\QH-3\:W>W>:9L=,FZLK)NL\99WOL\EF6YR MWAO?_V;OOC<;[H/4^RH!%_*[4=UO8S8\I.U^N(,3_M^"O_]:+!0_:\:OO/ < M#YS.'9]RR*N\<:W.F\C)KC&KT1QFB8N<WQ_?\<H#2VF,C_S+,V=YD%WN2T>G MF>?_at_K7E82C[=F]L8Z#AO><1C_N.<3U?H8"%Z?Z6.8:J7E^E1-OI(K7Y>K/\9 MZE^A.M*;KG2NJW?I9H=YV_at_E^<*:F'.1.+_K/O7YHK?^4[NJV>Z+![A6QX[W1 M?W=XX"%N];'??>U/MCABWR[SN+M[[HAO/-S+KO?J*IZ:C"=[W U?XLAK7O)' M'[S:^=X5OWO>S*=?<NKKKO;*+WKU_at_&_[2S.?=<<_GO*0=_UE8>]OW6OX\E:E MO>I]_WO>"][XA"?^BI$_<>63G/1Y7#&]\TD^?;97/_&%%_W+-P]\M]M<Y4[G M/"W%?^/KB]G\J$>_R;L_^^]/GOO,W_[.T:[^/]>_ZM#?BNPOPOY--Z7_/_at_& M%B& /$& BB5[^S<5MK> #-B #KA3" AKQ#9LQ5:!3T2!%AA'&1AL&#A'';B! M:/2!(/AK$?]H<]R&;=^6_at_I(D52HH;=W6_at_J'T_at_LHF@S#(2318@]G&?_at_DH%=)G M>^2W>_<7>T%X>_,7?W26?UK1_at_X[W@^8VA%V7?48(6T[88B4X=$'(A,F7>UH( M?B2&A5.&A.1VA=K'A786A4GW?J%GAE$&AO8FAFI8>[_at_7AVC8A6,8=/0F?*RW MA'5XAFDXA%X(<%,H<%48=6X8B()HB'-8AGZXAUN'B!IU<LZ$AWGG_at_XQX>([X M>9BHB'HXB&%7B)3XAIUWB7"8B/GUA[#%A_at_CGB9LHBL.WA:28:*PH:9S8=ZH( M?[$XB7((>G0(BNJ&BE:AA+;HBGW8>L(X<Y"89>ZGB\98B:%8C*-6.(SPYXM5 M`8SAQXSC9XWE1XRYN(RS6'JU6(V\F(W;^(R[>(M7UXW1]XTY9XK]A(U J(U% M:(Y/*(U408WKZ(Y-Z(RM.(ZL=HRDEHR9N'+LJ'#ZF(?QN(G_]#_at_5]LB-\IB% M_&B0T B."<F#E[:#$&61.V& .J&1$L&1..&10Z&#8_& )%F2)GF2Q82.1K22 M+%D1*IF$$SB",BD)(CB3:F23M%:3IH:3L::3/+F3$QD5+.B"*(B#*7B#1AE) M2)F4C[24-EB43&E)3AF5GB22`$F.#%F0E_at_>%#=E\"'F'5[F/P?B06[F(X?B. MT0B65DB&`HF/8766^<B6L/B5*!>6$'F/</F672E_REB*;OF%:DF(<KEJ`WE^ M6ME[A\EP5KF6KTB8?PF(B>F0!YF6=<F8?=F/CZE?D>F59)EJ_HAL=HF+8SF9 MI'F994F7D1B:B+F*FYE9]->:11B4/U"QD&V9E\NWESWWFIVIF"\9AH.I:H6I M<;_at_IA? 8D7_at_IFT]!FYAIFY"YFY)IG-R(G$ZAG([)G)KIG)Q9FM$9F/^=^)N> MF9GM:)WA:9;#R8?;69F"V9C "9X$B9U\68ZHB8R6&9#+69Z-")O$Z9ZQR9VT MZ)V\:9^6B)_FJ8F4F9KSB96U":#-J)_YJ9VU*9U-09WK*9[MZ:!B"9T/RI^E M5Y%;`9(VX:$U`:(-(:(S0:(!V)M8_at_9(JNJ(LVJ*+&74Q^9,5Z),R6D4T6J/& M-J,X:FL[RFLOVHDG.)14&:1#6I5"6J1*"97--I5(.FU*VJ3/]J/]J9[?2:&& MR: #ZI=6VGD06FKJF)586G%<*:!EV*5+(:%5JJ#7N*4Z9YJ0QIZ'9Z9*_at_:;_ M2:8<5YSP6:#RF9YNFJ9VVF>Z::'5*:=)0:="IQ:<;9JG5%I\:NIOA(H4AOJG MZ\>FWQ2H&(J9>*2:Q]>HJRFHI^F?'D>IET5*K918W_at_BJDOIZG!J7BQJJJ^I@ M2Q5H_QT6$Y$:IG=JJPOJJ=\9J^(VJS!1J[H*;Z(Z=>29JO#&JP;GJR\!K)<Z ME[BZIJ]ZFWJ(K&LEB9T*CM':G,'ZG(IZC\U$1:5EK9OZB=EZG=N:G<VZGBIE M1Q:EK"[!K-T:KP3:JJXYK&&U5%!$:"_EKBT!K_.:KF\ZIL_ZIK%*DW%FJNF(
MJ_at_-;=>4ZGGCZK\O(JW&VK^+*K6!ZKO5:K O[>]2*6/S*$OZJI0U;H0`[KAOK
M<1T;KAC'H9F&D1OILCEAH_at_HALS!!LQF9LE;UL2OAHCS;LRC9H[MV1QS6DD2;
M+4<*I3$(68I4M$SK*/:Z8DT;M;NQ;!+T,2 [LG<GM5KK,4,%TCCA8S*R.JU;
M.[;^X[56VSV$LU)B2[9LNSR9D1\M,SAK`S,>,BM^$QU<,TVEM;9MV[=_at_6SG6 MPST:\C0Y4CW:LZ]\N>NWBHLVAQ,TQL,]&U.X&Y.LB;NXEENUN).Y!*0RGB,E MG=NKE7NYHML?B_(V($(JGRNYKD*YW#>ZKINIC7LI1^(RD1LUBK-6H?NZNOLQ M*$,MG[,8P4) L^(T_at_Y.SN;N[R#N-6%MBR=N\OMFZSAN]];B\URB]UBN4U-M; MU[N]$9J]H\J]X NIWJM4X5N^1/&T^&:^ZAL4Z.M7Z_N^/=&^[0B_])L3,$L4 4$UN_^OL2#;B__ON_`!S 01$0`#L`
`
end Received on Wed May 19 1999 - 12:19:09 CEST

Original text of this message