I can create filters on string fields, for example  tag='abc' , and would like to be able to filter on UserLink fields as well.  Can this be done, and if so what is the syntax?

I have the same question for LookUp fields, too.

Cheers

Richard

The full syntax for filters is not SQL as suggested by the on-line help, but is defined by the .NET Framework dataset, more specifically the DataViewSetting.RowFilter Property. Details can be found at http://msdn.microsoft.com/en-us/libra... .

In summary, comparison operators can be < > <= >= <> = IN LIKE , boolean operators are AND OR NOT ,  arithmetic operators are + - * / % , functions are CONVERT LEN ISNULL IIF TRIM SUBSTRING .  Precedence is supported by ( ) brackets.

The IIF function supports conditional values, answering another question I had on computed values.

Field names containing any of these reserved constructs or spaces can be enclosed in [ ] or in single quotes.