Sorry about the formatting...apparently, the posts get leading spaces stripped?



Table Structure

.....WorkOrderMaster

..........woindex (PK)

..........partindex (FK)

..........etc.



.....PartMaster

..........partindex (PK)

..........divisionindex

..........etc.

(bump)



Table Structure

WorkOrderMaster

woindex (PK)

partindex (FK)

...

PartMaster

partindex (PK)

divisionindex

...



I am trying to limit the browse dialog to only those work orders that have parts in a specific division. The SQL would look like this:



SELECT WorkOrderMaster.* FROM WorkOrderMaster LEFT OUTER JOIN PartMaster ON PartMaster.partindex = WorkOrderMaster.partindex WHERE PartMaster.divisionindex = 1

Good afternoon!

I have the following code working within a browse dialog.







The problem is, like always, speed. There are 1250 parts in the mPartsBO--more in the other division. The delay seems to be building that array. Is there any easier, faster, more economical way to reference the partindex field in the BO collection?



Thanks!

Bill