>Notice that send updates = .t. and update type is 1

I'm don't understand the significance of this.



>Download the EView from the files section and it will make your life in VIEWS much easier.

Will do.


>I use Mere Mortals, an adaptation of CodeBook.

Good, I use Visual FoxExpress, also based on CodeBook, so we speak the same dialect of VFP.


>The difference I see is that I use a child view differently than you. I am not linking all the child records to all the parents. I am more C/S in that you only return childs on a parent. Change a parent, requery() the child.
>
>This is important in large transaction environments IMHO. So add a vp_ to that view query! " and AITEM.custno = vp_custno"

Seems like I am doing the same thing. I have a global app pointer to the parent account record (goApp.iACCNTS) and the requery() gets only the child records for that parent record.

create sql view lv_AITEMS as ;
select dtoc(AITEMS.tEffective) as dEntered, ;
ITEMS.cItem_Code as cCode, ITEMS.cShort, ;
iif(AITEMS.nDaysDue=0,space(10), ;
dtoc(ttod(AITEMS.tEffective)+AITEMS.nDaysDue)) as dDue, ;
AITEMS.yAmount, AITEMS.lClosed, 000000.00 as yBalance, AITEMS.tEffective ;
from MASS1!AITEMS, MASS1!ITEMS ;
where AITEMS.iITEMS = ITEMS.iITEMS ;
and AITEMS.iACCNTS = ?goApp.iACCNTS ;
and (AITEMS.lClosed = ?goApp.lSeeClosed ;
or AITEMS.lClosed = .f.) ;
order by AITEMS.tEffective


I may have some question for you later if you would be so kind.

Peter