Advice Required

[Peter Bateman]

Hi Robert:


  1) QUIZ can retrieve a result set from a stored procedure ( actually from 
a package )

   or 2) QUIZ can retrieve data through a cursor

   or 3) QUIZ can use tables in a manner similiar to indexed file.

I would choose option 2 .
if your thinking of using some other reporting
tool you could save yourself sometime by using 1 if the new tool allows 
stored procedure calls .


You can link to a cursor by having host variables define in structures 
higher up in the access statement.
SQL IN <DB> DECLARE XCURSOR CURSOR FOR SELECT A, B, C FROM X WHERE X.Y = 
:SUBY
; SUBY is an item in SUBFILE
e.g. ACCESS *SUBFILE LINK TO XCURSOR

Regards,
PETER

_________________________________________________________________
Powerful Parental Controls Let your child discover the best the Internet has 
to offer.  
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines 
  Start enjoying all the benefits of MSN® Premium right now and get the 
first two months FREE*.