This is sort of glossed over in the VFP documentation.

But I have a set of tables in the DE. I want to open some of them based upon a memo field in a table called sys_conf (also opened up in the DE).

My thinking was that I disable teh AutoOpenTables prop, then in the OpenTables event code I just do:

local i, llFound

use lbview
use logbook
use samproj
use testproj
use sys_conf

llFound = .f.
for i = 1 to memlines(lb_config)
	if llFound
		lcAlias = alltrim(mline(lb_config, i))
		if lcAlias = 'END'
			exit
		endif
		use lcAlias
	endif		
	if MLINE(lb_config, i) == '[YARN]'
		llFound = .t.
	endif
endfor	

But it blew up on me. Got an error that the jist of it was: "you tried doing something you shouldn't" After playing around with it for a little while, I thought, why not ask the lovely and knowledge folks at UT.

Firstly, is it possible? Secondly, and pointers, tips or articles you can refer me to? Thanks.

hrmp

tia
matt