>I have noticed that when you modify the structure of a table, there is an option on the right side to add field comments as well as other things. This always seems to be an inactive option, how do you enable these for input? Once there is input in them, how do you reference to pull this information from these in a program? For example, I would like to put in the field comments a description of what the field is used for, then in my program I would like to display these descriptions as the fields are advanced in a combobox to give the user the option if they want to add the field as one they would like to pull for a report.
Here how you can add comments to the fields (kerep in mind this is only possible for Tables that are in DataBase, For Free tbables you can't add comments.
USE Yourtable EXCLUSIVE
MODIFY STRUCTURE
How can retreive this information from Table
OPEN DATABASE DBWhereYourTableIs
SET DATABASE TO DBWhereYourTableIs
Use YourTable
FOR i = 1 TO FCOUNT()
? DBGETPROP("YourTable."+FIELDS(i),"FIELD", "Comment")
NEXT
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.