>I go to create another bizobj based on lrdataobj to open the next view the loanrevenvironment with the previous table appears I try to remove the view from data access and add the newone and everything goes haywire, I also tried to add a new dataenvironment for this business object and that did not help. What am I doing wrong this time.

You need to create a new dataenvironment for each bizobj. We create a base DE for each of our Databases. Then, when we are creating a new bizobj, we base it's DE on the base DE for the database that the table resides in. In other words, if we have a database named "loans", we would create a DE called "loansenvironment" and base it on cdataenvironment. Now, let's say that that database contains a table called "customers". We would create a view called "lv_customers" and add the customers table to it.

Next,create a bizobj called "customerobj" based on either kbizobj or your subclass of kbizobj.(The reason we subclass kbizobj to abizobj and base all our bizobjects on abizobj is so that we can add our own properties and methods to abizobject that all our bizobjects need and we don't have them wiped out when we upgrade to the next version of the framework.) In the bizobj builder, we would create a new DE called "customerenvironment" that is based on "loansenvironment" and add our view to it. Save it, compile it, create it, test it!

That's all there is to it. You can crank out tons of bizobjects a day if you need to.

happy coding