List of Fields

Hi, I’m looking for a way to show all the fields of a Table, so the user ca select one of them and store its data (i.e. fielno or fieldname) in another table for future reference. Is there any system table which stores that kind of information ? Thanks in advance

Yes, Table 2000000041 Field.

quote:


Originally posted by nelson
Yes, Table 2000000041 Field.


Thanks Nelson, but this is a virtual table. I cannot use it in a TableRelation.

Sure you can, why not?

quote:


Originally posted by nelson
Sure you can, why not?


Ok I can.Bad question. Then how can I take the actual field (based on fieldname) of the table and perform i.e. a TESTFIELD checking ?

Ah, Watson, I knew the true question would eventually present itself… [:D] You will have to use RecordRef, FieldRef, etc. One good place to start digging for info would be following Emiel’s sample code which you can download at: http://www.mibuso.com/dlinfo.asp?FileID=276