>I must have a mental block when it comes to SCATTER/GATHER.
>
>Here's my code:
>SELECT TABLE1
>SCATTER NAME oTable1 MEMO
>
>How do I define oTable1 and populate it? I thought SCATTER would automatically make oTable1 and stick the table field values into the object for me.

It should. e.g.,
CREATE TABLE testname (ctest C(10), mtest m)
INSERT INTO testname VALUES ("Testme", "This is a test memo field")
SCATTER NAME oTable1 MEMO
? oTable1.ctest
? oTable1.mtest