Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Forms & Form designer
>The reason I asked, is because I too have had very erratic behavior on grids especially using multitable related fields. In my most recent case, I need to sometimes interactively create a link to match related data from the parent to the child table (In case the child table does not have the matching field, it is created on the spot). But what happens is the indexes go awry, and all kinds of mixed up data fill up the grid, with no correlation to the parent data. A reindex at this stage would have been v. useful!
Use Cursors/Views/SPT/CursorAdapters to pull the data instead of SET RELATION. Indexes will optimize the query. No reindexing required.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only