@AF Clarification Needed...

[Stanley - stanlyn-com]

Hi,

 

Does the @AF function and behavior work the same whether the table is
structured as in table A and table B below?  I am having problems with @AF
when using it with table A below, and NO problems with table B.  Define
Proc=5.0.14D4, sco OpenSrv5 

 

Table A (with each associated field in a block where they are NOT next to
each other)

90- I2) Item #1        

91- Q2) Qty #1           

92- M2) UOM #1           

93- D2) Desc #1          

94- G2) GL #1            

95- T2) Total Cost #1    

96- *                    

97- *                    

98- I2) Item #2          

99- Q2) Qty #1            

100- M2) UOM #2           

101- D2) Desc #2          

102- G2) GL #2            

103- T2) Total Cost #2    

 

 

 

Table B (with each associated field next to each other)

38- D1) PayDate #1        

39- D1) PayDate #2        

40- D1) PayDate #3        

41- D1) PayDate #4        

42- D1) PayDate #5        

43- D1) PayDate #6        

44- D1) PayDate #7        

45- D1) PayDate #8        

46- D1) PayDate #9        

47- D1) PayDate #10       

48- *                     

49- G1) G/L Code #1 

50- G1) G/L Code #2       

51- G1) G/L Code #3       

52- G1) G/L Code #4       

53- G1) G/L Code #5       

54- G1) G/L Code #6       

55- G1) G/L Code #7      

56- G1) G/L Code #8       

57- G1) G/L Code #9       

58- G1) G/L Code #10      

 

And yes, I know how to normalize.  This is legacy code that needs some small
changes to the @AF stuff.

 

Thanks, Stanley

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20111003/49ae2b67/attachment.html