Get fields for all table by macro

[#1]

Hi to all,

how can I get the list of all fields for each logical table?

I found GetTableCount, GetTableName, GetTableNumber in the Api.

Is ther a method to get fields for table or to get table for each fields?

Thanks

[#2]

Hi,

Try this in a list box. $Table--> This will give you the list of table you have.

$Field -->This will give you the list of fields in a table.

Thanks

Saran.

[#3]

Hi,

You must use the system files $Table $Field with the function concat like as follow:

= concat( distinct $Field, ';' )

This let you see all the fields name in a text object.

I hope this help you.

Best regards.

[#4]

If u are askng fr GUI part then u can get.

in properties select "NewSheetObject" in tht u select "currentSelectionsBox"..

[#5 · Accepted solution]

Ok, I solve with SrcTable method.

Thanks to all

[kevinpintokpa]

Hi Stefano,

What is the SrcTable method that you refer to?  I searched for it but could not find any information.

Thanks!

Kevin