creating a list of records from a table

[tinkerz1]

Hi can I take a table and turn it into a list??

Message was edited by: Neil Woodham

[tinkerz1]

This is great thanks,

Can you crosstable load and perform an inline function from table already loaded?

Thanks

[swuehl]

INLINE LOAD is just for demonstration, use a resident table load with your real data:

CROSSTABLE (Field, Value)

LOAD

  recno() as ID,

  * ,

  ' ' as ' ';

LOAD RecordNo, Name, Address

RESIDENT YourResidentTable;

[tinkerz1]

Sorry about the repeating questions, what does the =1 in the expression do?

[swuehl]

It's kind of a dummy value, a straight table needs an expression, and a constant value <> 0 just shows all lines (selections will still filter dimensions). Remember, the expression column will be hidden from the user.