Hi

I am designing as workqueue screen for my application and I need to display information from several tables in a gridview.

I have created a view in my database (SQL Server2000) named WorkQueueand I am populating it using the method WorkQueue.GetMulti() .

This covers 90% of the data I need however I also need to retrieve an additional collection for each row in the grid and display it..

Is there a way to prefetch this collection?

Thanks

Aidan

Can you not define the relation in the GUI designer? Once you do that, you can do a normal prefetch.

WayneBrantley wrote:

Can you not define the relation in the GUI designer? Once you do that, you can do a normal prefetch.

Hi Wayne,

I cant defien the relationship because its a 1:N relationship and the designed doesn't let me define a 1:N relationship on a view because a view doesn't have a primary key ....

You can specify the PK field(s) for an entity mapped on a view in the designer as well Just open the entity in the editor, select the field, and check the PK checkbox.

Otis wrote:

You can specify the PK field(s) for an entity mapped on a view in the designer as well Just open the entity in the editor, select the field, and check the PK checkbox.

That solves my problem

Many Thanks !!!!

Aidan