Friends: When I am using a DataMethod for a field, logically I can not use filer on that field when I am running the form. What should I do, except using Temporary Table. thanks
I want to do the same on a Display method. I thought the solution is InnerJoin - you join two or more tables and grab the fileds you want directly in the Form. You solve the Filter problem. However, there are other problems with it. If this is what you are also looking for, check this topic (no solution yet): http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=14297
quote:
I thought the solution is InnerJoin - you join two or more tables and grab the fileds you want directly in the Form. You solve the Filter problem. However, there are other problems with it.
The problem is when you don’t use a data coming from a table. For example in my case, I have a check box in a grid. This check box calls a display method that return true if the client is a woman and has more than 5 sales (for example). This information is not a specified field of a table. So I can’t make an Inner Join as you say… If someone as any idea… Vince
Sorry to disappoint you all, but it really can’t be done. One solution is to use a TempTable, but that’s a bad one. The other one is adding the fields you want to sort on into the table the grid is based on, and filling them in all the time when necessary. But it’s not a very good one either. If you really need it, just use one of these methods. But I don’t recommend it
You could create a View that includes the fields you need. Use this view as the data source instead of a table. The only downside of this approach is that Views are read-only, but you only need it for grid that displays data, then it’s not a bad choice.
This can be useful,
I was able to filter but not to sort though