I have created a user defined filed called route, type character and created a list table for it. Everything looks ok. I have added it to my main log form. It's there and the drop down list works. However, it doesn't show up in the "list all user defined fields used in log" and I'm not sure why. Any ideas? Also can that field be added to a report. I don't see it in the expression builder fields box.

Dave, NW3U

G'Day Dave,

You actually have to use the field before it will be in your log. The factory log field USERFIELDS, in every QSO in your log, is scanned to see which "user fields" have been used. It is a good way to look for errors in USERFIELDS, particularly if you edit the fields by hand. Look for names found only in 1 QSO or names that look misspelt or are unknown to you. Editing USERFIELDS by hand is not a good idea.

There are functions to read, edit, and update user fields in a QSO. In Help, look in Advanced, Expressions and Functions. Also Tools, Advanced, Database commands has special facilities for editing user defined fields. Look in Database Files, Mass Change.

You will not find "user defined fields" in the Expression Builder. User fields are a special facility in LOGic and unknown to the generic Foxpro tools. In a report, you need to use a LOGic function to extract the user defined field from the log text field USERFIELDS in each QSO. Like this ...

GETUSERFIELD("JCG:")

or the older format ...

TAG_VAL("JCG:",USERFIELDS)

There is a lot of material on the forum on user defined fields. Search for "user fields"

Use Forms, All Log Forms, and load the special USERFIELDS log form, to see what is happening with your user defined fields.

You may also find these reports useful.