Here is the scenario. I am using VMP4 and have a datantry form with 2 grids on it. I have one table. I want to separate the table dependent upon a field value into the 2 grids. Basically if rows in the table have Field A = "1" then it displays and is editable in Grid 1. If rows in the table have Field A = "2" then it displays and is not editable in Grid 2.
I think one way to do this is to create 2 indexes that are the same except one has a filter set to FieldA == "2" and the other index has FieldA <> "2". Then somewhere I set the order back and forth using the indexes. I'm not really sure how this would work though. Is there maybe a way to specify to the grid to filter using a pre-defined index?
Thanks in advance.
George Scapin
g@thescapins.com
www.thescapins.com