>>Is it proper to change the CURSOR SOURCE? Inotherwords, is that
>>done a lot?.
>>I can not thank you enough - .. :)
>
>I don't know if I'd say its done alot, but it is the only way to provide multiple data sets in different places and let your forms work wiht them all.
You can also do something like the following in the INIT of the form or object (I did mine in the INIT of a listbox):
thisform.DataEnvironment.CloseTables
thisform.DataEnvironment.AddObject("Dealer", "CURSOR")
thisform.DataEnvironment.Dealer.CursorSource="dbf\Dealer.dbf"
thisform.DataEnvironment.Dealer.Alias="Dealer"
thisform.DataEnvironment.OpenTables
However, my DE initially contains no tables (cursors). In other words, I didn't add any tables at design time (Hence AddObject as opposed to simply changeing the cursorsource).
Whatever works best!