Thanks Tim. I appreciate your help.

Guy


>The theory is if you create a stored procedure you can run the BLG against that stored procedure. I have not done this because there is little value in creating business objects based on a stored procedure. You may get an entity object you could use but would have to do some modifications to it so it would be useable in the business object you want it in.
>
>That said, for lookup data it is just easier IMHO to use a DataSet.
>Tim
>
>>Thanks... that is helpful.
>>
>>
>>>Hi Guy,
>>>
>>>I had this problem before. I don´t know how the BLG can create an Entity with fields from two tables. I solved it creating a copy of the main Entity, renaming the file and the class and then adding the new field copying it from the parent Entity. Then in the BusinessObject create the corrsponding method:
>>>

GetEntityList<NewEntity>(param)

>>>
>>>Sorry if this would not help you.