hi all,
I have a problem. what i am trying to do is simple enough, I have 2 call systems, both held in seperate folders but build on the same framework, they use tables of the same name, but in different folders, etc. I need to pass details from one to the other, befor ei was creating a dbf with 1 line and saving it into a sub folder. then a timer in the other program would import it, only problem here was that it the users was doing something in the second call system this would cause an error. So what i decided to do was this

mlocation = ALLTRIM(TBD_valx3) + "zfnwc"    && Getting the file location
SELECT 0
USE &mlocation ALIAS 'NWC2'
SELECT NWC2
SEEK lclcalnum ORDER CMA_calnum
IF FOUND()
	* should not happen - do nothing, as call already there
ELSE
	* add in the details to the limited system
	SELECT NWC
	SCATTER MEMO MEMVAR	
	
	SELECT NWC2
	APPEND BLANK
	GATHER MEMVAR MEMO
	....   && have a few replace field1 with " " lines in here
	SELECT NWC2
	USE

this works but on the save of the form there is a requery that is necessary and it gives me this error.
1542/Base table fields have been changed and no longer match view
Now these tables in both folders are fine but this error always comes up. any ideas?
~M