>I have a few questions...
>One...
>
>Can you open a second datasession programmatically? If you can please point me in the right direction.

Yes. You have to have at least SP3 for VFP and create a Session object. This will give you the new datasession.
Ex.
oSession = createobject("Session")
set datasession to osessio.datasessionID
< open my tables here >

Or you can create a subclass of the session object and create methods to open your tables and perform whatever operations you need.

>
>Two...
>
>If you can, and you open a table that is already open in the first datasession. Will the updates from datasession two be seen real time or only after the table in the second datasession closes or not at all?
>

See SET REFRESH in the help. Or you can always issue an Rlock() in the second datasession to refresh to buffer and unlock it immediately.

>Thank You